Discussion Locked

IIS and Access

0 helpful
1 reply
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Here's the jist of it. I'm trying to use ADO in an ASP website to try to connect to an Access Database on another NT Server, I have the drive mapped and have tried UNC. It won't connect. If I bring the DB locally it works fine. But if its on a remote machine, it won't let me access it. I get the following error.
The Microsoft Jet database engine cannot open the file 'm:\aaron\Security.mdb'. It is already opened exclusively by another user, or you need permission to view its data.

Help, Please?

1 reply

by tanis22

The problem may be occuring because of the following:

When you are going to the site and making the connection locally, you are logged in as the current user who already has permissions to the database file.

Since you are wanting the database to be available remotely, you have to go to the database file and set the permissions so that the IUSR INTERNET account has access to read andview it (The user you have for anonymous WWW access.) This should clear up the error that you are getting, because currently the WWW account is denied permission to the file.

This discussion is closed to new replies.