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?