SQL CE not loading from network share

Question

I installed VS 2010 RC yesterday, and suddenly, SQL Server CE isn't loading files from a network share. In projects compiled with VS 2008, if I try to open a SQL CE file located on a network share, I get an error that reads like this:

Internal error: Cannot open the shared memory region.

If I try to create a data connection in VS 2010 to a SQL CE file on a network share, I get this error:

SQL Server Compact does not support opening database files on a network share.

Can anyone shed any light on what's going on? Thanks.

Answer 1

SQL Compact is a single user, in-process database engine, for network based databases, use the free SQL Server Express.