Can't open Access database connection

[chriscanali]

Whenever I try to open a connection to an access database with .open (in a Web Application) I always get the following:

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

I just have the default "admin" for the database name, with no password. I don't have Access open. I can't figure it out, any help would be much appreciated.

[chriscanali]

When I said above "admin" is the database name, I meant the user ID

[bruce]

this is usually an error produced by MS Access client.

Do you have other pages that has the DB opened exclusively?

Bruce

DiscountASP.NET
www.DiscountASP.NET (http://www.DiscountASP.NET)

[chriscanali]

I figured it out. I had to go to the Security tab in the properties for the .mdb and for the folder it was in and add a user with ServerName\User (with full rights). The Server Name being my local machine name, and User is ASPNET by default.

[chriscanali]

BTW, in case anyone is trying to do this too and doesn't have a Security tab in the properties window, go to Folder Options in Windows Explorer, and uncheck "Use simple file sharing (Recommended)".