MSDE sharing on peer-to-peer network

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?
2. If this can be done how will the performance compare? There are up to 40
tables containing up to 150MB of data.
Thanks
Terry
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.shtmhttp://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
|||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:
> 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..
>
> 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.shtmhttp://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
>
>
|||Terry,
The answer is yes, giving that MSDE (SQL Server) is running on
workstation 1 (it is a program, not just a database "file") and that the
user on Workstation 2 has the necessary "rights" to access the database.
Lars Broberg
Elbe-Data AB
http://www.elbe-data.se
Remove "nothing." when replying to private e-mail!
Terry wrote:[vbcol=seagreen]
> 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:
>
sql