Problems connecting to MS Access Using ASP.NET

I wanna retrieve userid from the UserTable which resides in Users DB, but I have already encountered problems when I even tried to open the connection. the error message goes like this: The Microsoft Jet database engine cannot open the file 'H:\Users.mdb'. It is already opened exclusively by another user, or you need permission to view its data. 1) i've tried giving full control to the directory where my databse and asp pages resides.. 2) i've also tried to configure the ASP.NET worker process to run under the SYSTEM account in the section of the Machine.config file. 3) I'm very sure that no one is has opened this database. 4) I've also tried to give permission to ASPNET USER but failed because my database resides in one of the drives in the network and it do not have ASP.NET program, thus it doesn't have APSNET USER. ASPNET USER only resides in my machine. Is there anyone else knows anything regarding this problem?

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

yibing2622y ago
Thanx for ur ans.. :)
+1
sacresp22y ago
Your item number 4 is the key. ASP.NET worker process does not have permission to access network drives. You have to choices. 1) You have to authenticate the web user (must be a legal domain user) and impersonate it. 2) You must set the worker process to run under a domain account. As you noticed, ASPNET is not legal. You could add ASPNET user to your PDC (or active directory), though.
+1