Terry wrote:
> Hello Andrea
> Thanks for the information.
> I think I worded the question badly in terms of sharing - I understand where
> you are coming from (I think). Can a user on, say Workstation 2 access the
> data in an MSDE database on Workstation 1?
> Terry
> =================================
> "Andrea Montanari" wrote:
>
>
>>hi Terry,
>>Terry wrote:
>>
>>>We have a Front End/Back End database. The Back End is stored in a
>>>shared folder on a per-to-peer network.
>>>1. Can we use MSDE to back-end the database and have up to five users
>>>access it from each of their workstations if we change the front-end
>>>to an Access project using ADO?
>>
>>you should not store SQL Server/MSDE databases in a network share, nor
>>should they be on a remote one..
>>users only needs to access MSDE, and thus data throught it's service and do
>>not need physical access to the database os files, both for security reasons
>>and technical perspective...
>>regarding Access/ADO, you actually do not need this path as you could go
>>with other model (c#/ADO.Net or whatever), but it's ok..
>>
>>
>>>2. If this can be done how will the performance compare? There are up
>>>to 40 tables containing up to 150MB of data.
>>
>>it dependes on your code quality and logic... avoid SELECT * FROM
>>myMillionTable and follow standard code quality and best practice for
>>database applications :)
>>you have to test your scenario...
>>--
>>Andrea Montanari (Microsoft MVP - SQL Server)
>>http://www.asql.biz/DbaMgr.shtm http://italy.mvps.org
>>DbaMgr2k ver 0.11.1 - DbaMgr ver 0.57.0
>>(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
>>interface)
>>--------- remove DMO to reply
>>
>>