Connect to access database on a shared folder

Question

Hi Could you tell me please how can I open a connection to an access database located on a shared folder? Thanks in advance

misk · Answer

Hi 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 Lysle · Answer

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?