SqlCE on Shared network folder locks the sdf file

Question

I have a .net application that uses SqlCE. I can easily open the database and then go to the folder where the sdf file is located and make a copy of it(We do that to create backups when user requests it). When I try the same workflow using a shared network folder, i get shared file access error saying another process is using that file. Does sqlCE open the sdf file differently when the file is on a network folder?

Answer 1

Hi @masud Hosseinian ,

Although SQL Server Compact Edition supports concurrent database connections from multiple threads and multiple processes, concurrent access is not supported when the database file is located on a network drive. SQL Server Compact Edition prevents it by automatically acquiring an exclusive lock on the database file when a connection is made to the database file via a network share.

---

If the response is helpful, please click "Accept Answer" and upvote it, as this could help other community members looking for similar queries.