Hi,
Could you tell me please how can I open a connection to an access database located on a shared folder?
Thanks in advance,
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
miskPosted Mar 15, 2008, 10:06 AM
I tried to use this connection string in a Windows application but it failed:
OleDbConnection aConnection = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=@\\ServerName\\SharedDocs\\CS\\db1.mdb; Jet OLEDB:System Database=system.mdw;").
When I execute the program, the compiler show me that that the database: C:\Documents and Settings\...\@\ServerName\SharedDocs\CS\db1.mdb is not a valid path.
Thanks for your help
Scott LyslePosted Mar 15, 2008, 4:54 AM
Typically you can use the network address to connect; if you have security issues I have put a virtual directory on the server and set the permissions to allow connection to the database; if it an asp.net application, you can either allow a specified user to access the folder or you can allow the asp.net account access.
What have you tried that does not work for you?