Greetings, I'm a little bit confused about SQL Server Compact behavior.
I have a small app that uses a small sdf file located on a network share.
The problem is that while the app itself is working perfectly well using the connection string that points the location of the sdf file on a network drive, when I try to open the same sdf using the Server Explorer I get this error:

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

Obviously, if the app IS working it does indeed support network shares, then why Server Explorer cannot open it?

I copied the database file to a local drive but it's not very convenient. What might be the problem?