How Do I Share A Sql Server Ce Database File (.sdf) For Multiple Processes?

I have a database in SQL Server CE. When connecting several applications of different computers to the database throw an exception. This is the exception: There is a file sharing

Solution 1:

I misread your question initially, but I don't believe SQL Server CE supports multiple connections from different computers.

From an MS guide:

When you require data service functionality, such as the ability to support multiple, remote users, you should start with SQL Server Express Edition and work up the data service family tree.

You can have multiple connections (up to 256) from the same machine, but connections from multiple machines requires SQL Express Edition. It's freely available and easy to deploy.

Here's the link: http://www.microsoft.com/sqlserver/en/us/editions/express.aspx