I have a .NET web application developed that requires it to access a MS Access (2002) Database on a remote PC on our network.


I am having difficulty making connection.

The connection string I have created is as follows.... Note that I have all variables declared and controls set up as well.

ConnStr_ReportServerDataFiles = "Driver={Microsoft Access Driver (*.mdb)};Dbq=\\ServerName\SharedFolder\SubFolder\MyDatabase.mdb;Uid=admin;Pwd="

If Conn_ReportServerDataFiles.State = ConnectionState.Open Then
Conn_ReportServerDataFiles.Close()
End If

dcCheckServer.Connection = Conn_ReportServerDataFiles

Conn_ReportServerDataFiles.Open() (It fails here)


I have also read about permission issues accessing remote access databases from IIS.

This link is one I have checked http://www.kbalertz.com/kb_307901.aspx

though I am a little lost on exactly what I need to do. Can anyone shed any light on what I have to do, or have a solution?


Many thx in advance!