arothberg


Can a SQL Server 2005 Compact Edition database file be deployed on a file share and be accessed by multiple (5-10) concurrent users This is a current scenario being implemented at several sites using MS Access databases.

Each client would have the SQLce engine installed on it and would only access the database via a managed C# application.




Re: Network share/Multi user deployment

William Vaughn


Ah, no. While you can place a .SDF on a file share, the first process that opens the file locks it for all other users. This is discussed in my new EBook. See www.hitchhikerguides.net.





Re: Network share/Multi user deployment

BrianSquibb

.... which is another good reason to use datasets with CE rather than the much pushed recordset model....

ie

open connection
fill dataset
close connection

would allow a certain amount of sharing

Brian