Error accessing MS Access Linked tables on fileshare in ASP.Net ap

Hi,

I have a ASP.Net application that uses a MS Access database. The site works
fine when all databases resides locally but on my public server I need to use
a different database where the main databasefile resides locally but also has
tables linked that resides on a fileshare/network drive.

When I try to run my app I know get an:
'database.mdb' is not a valid path. Make sure that the path name is spelled
correctly and that you are connected to the server on which the file resides.
The database.mdb file is one that resides on the fileshare.

I suspect that this has something to do with permissions on the remote
machine but I don not understand what I need to do. I have tried to use
impersonation by adding the tag to the
web.config file but that only seems to work on my win XP machine running IIS
5.1. When I try to do the same on the server (Win2K running IIS 5.0) I get an
"Unspecified error" when calling Connection.Open().

Does someone know a solution? Am I even posting this on the right forum?

Best regards
PÃ¥l Eilertsen

Re: Error accessing MS Access Linked tables on fileshare in ASP.Net ap

Pål Eilertsen wrote:
> Hi,
>
> I have a ASP.Net application that uses a MS Access database.

There was no way for you to know it (except maybe by browsing through some
of the previous questions before posting yours - always a recommended
practice), but this is a classic asp newsgroup.
ASP.Net is a different technology from classic ASP.
While you may be lucky enough to find a dotnet-savvy person here who can
answer your question, you can eliminate the luck factor by posting your
question to a newsgroup where the dotnet-savvy people hang out. I suggest
microsoft.public.dotnet.framework.aspnet.

But read on:

> The site
> works fine when all databases resides locally but on my public server
> I need to use a different database where the main databasefile
> resides locally but also has tables linked that resides on a
> fileshare/network drive.
>
> When I try to run my app I know get an:
> 'database.mdb' is not a valid path. Make sure that the path name is
> spelled correctly and that you are connected to the server on which
> the file resides. The database.mdb file is one that resides on the
> fileshare.
>
> I suspect that this has something to do with permissions on the remote
> machine

Good suspicion. This is the same problem you would experience in classic ASP
so I will direct you to this link:
http://www.aspfaq.com/show.asp?id=2168

You will need to adapt what it says to the .Net environment, but the message
is the same: permissions.

> but I don not understand what I need to do. I have tried to
> use impersonation by adding the tag
> to the web.config file but that only seems to work on my win XP
> machine running IIS
> 5.1. When I try to do the same on the server (Win2K running IIS 5.0)
> I get an "Unspecified error" when calling Connection.Open().
>
> Does someone know a solution? Am I even posting this on the right
> forum?

See above


--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.