is it supported to open a SQL Server Compact Edition 4.0 file from a network share? I read elsewhere that this is supported when you open the database in "exclusive" mode:
"The ability to open a file on a network share in an exclusive mode is a feature for SQL Server Compact 4.0."
However this does not work and I get the error message:
Internal error: Cannot open the shared memory region.
If you neerd to access a database across a network, you should use SQL Server (Express). I am not sure that the information in the connect comment reflects the actual implementation, which is that network access is not supported.
Please mark as answer, if this was it. Visit my SQL Server Compact blog