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 <identity impersonate="true" /> 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

[quoted text, click to view]

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:

[quoted text, click to view]

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.

[quoted text, click to view]

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.