IIS Problem (remote Access DB & asp)?

  • Thread starter Thread starter Fields
  • Start date Start date
F

Fields

Guest
Whenever I try to connect to an access database, I am receiving this error "The Microsoft Jet database engine cannot open the file '\servername\mydb.mdb'. It is already opened exclusively by another user, or you need permission to view its data."

I can fix this problem if I enable anonymous users. This would be fine, but if I do this, I cant retrieve the session variable LOGON_USER. I have to be able to pull the username for a project.

I have given everybody rights to the database and to the asp pages, and I still get the error. I'm about out of ideas. Putting the DB on the web server is not an option. Both servers are running 2003.

Any ideas?
is there a way I can get it to run as domain user instead of IUSR? I think this would fix my problem
 
Back
Top