Connecting to a Remote MS Access Database

[Islesfan]

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!

[jas4th]

What it is saying is that when you run your ASP .NET app by default it uses the account for running that process. Now if that account doesn't have privelidges on your ACCESS mdb and mdw files then you can set up impersonate another user (or even the current user) so that it will use that account's priviledges - assuming they have enough.
This is altered in the web.config of the app as shown in the article.
There are tricky issues with passing NT tokens from one IIS server to another server.