SQL Server CE 4.0 network share access In our application we are planning to use SQL Server CE 4.0 using OLE DB. The connection string is shown below.

Dim strConn As String = "Provider=Microsoft.SQLSERVER.CE.OLEDB.4.0;Data Source=\\pc137\d\desktop\mydb.sdf; SSCE:Database Password='password';"
Dim conn As New OleDbConnection            
conn = New OleDbConnection(strConn)            
conn.Open() 


This one worked for both the local and network share files (.sdf)

We tried to connect using Visual Studio for the network share we get following error 


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


We have referred this links  

So is it allowed to connect SQL Server CE 4.0 using OLE DB in network share?

Does it cause any other problem?
No, this is not supported. And using the Oledb provider from a .net application is not supported either, use the Ado.net provider (System.Data.SqlServerCe)