Access, ASP and a remote server

[ChristoL]

Good day all

I have a c# and asp.net web page going. I am use two db's (both MS access). The one is my own in a folder app_data in my root. I can use a asp:AccessDataSource with the datafile = "~/App_Data/myDB.mdb" and that works fine. But now I need to access a db on a remote server as well.
Now as far as I can gather, an asp:AccessDataSource uses only relative connnections, so accessing a db on a remote server is not possable.
I tried using an asp:SqlDataSource and added an IIS_WPG and an ASP.NET Machine Account with full control and I still get a

The Microsoft Jet database engine cannot open the file 'TheirDB.mdb'. It is already opened exclusively by another user, or you need permission to view its data.

error. Where am I going wrong?

My asp.net code is as follows:

<asp:SqlDataSource ID="SqlDataSource1"
runat="server"
ConnectionString="<%$ ConnectionStrings:TheirDBConnectionString %>"
ProviderName="<%$ ConnectionStrings:TheirDBConnectionString.Provider Name %>"
SelectCommand="SELECT [MFRMfrName] FROM [MFR] ORDER BY [MFRMfrName]">
</asp:SqlDataSource>

Web.config:

<add name="TheirDBConnectionString" connectionString="Provider=Microsoft.Jet.OLEDB.4.0 ;Data Source=\\Intranetserver\TheirDB.mdb"
providerName="System.Data.OleDb" />

Help please

[leoiser]

Make sure your folder having correct access rights.type \\Intranetserver in run

if you can not access,then it is the access right problem.Option is Set the DB folder in FTP Sites (in IIS) , it will solve the issue.

Good day all

I have a c# and asp.net web page going. I am use two db's (both MS access). The one is my own in a folder app_data in my root. I can use a asp:AccessDataSource with the datafile = "~/App_Data/myDB.mdb" and that works fine. But now I need to access a db on a remote server as well.
Now as far as I can gather, an asp:AccessDataSource uses only relative connnections, so accessing a db on a remote server is not possable.
I tried using an asp:SqlDataSource and added an IIS_WPG and an ASP.NET Machine Account with full control and I still get a

The Microsoft Jet database engine cannot open the file 'TheirDB.mdb'. It is already opened exclusively by another user, or you need permission to view its data.

error. Where am I going wrong?

My asp.net code is as follows:

<asp:SqlDataSource ID="SqlDataSource1"
runat="server"
ConnectionString="<%$ ConnectionStrings:TheirDBConnectionString %>"
ProviderName="<%$ ConnectionStrings:TheirDBConnectionString.Provider Name %>"
SelectCommand="SELECT [MFRMfrName] FROM [MFR] ORDER BY [MFRMfrName]">
</asp:SqlDataSource>

Web.config:

<add name="TheirDBConnectionString" connectionString="Provider=Microsoft.Jet.OLEDB.4.0 ;Data Source=\\Intranetserver\TheirDB.mdb"
providerName="System.Data.OleDb" />

Help please