[discostew99]

I'm using an .asp page to connect to an MS Access 2000 db using ADO. Everything works like a charm on the web until I open and close the database (to do data entry, etc.). At that point I get the following error in Internet explorer when I access the .asp page. At this point the db is closed:

Provider error '80004005'

Unspecified error

/HR/Training/Home Office/CourseDesc.asp, line 26

Line 26 is my connection string (Conn.Open strDBName).
I only get this error some of the time. It's not at all consistent. Within a 1 minute period I may be able to connect 5 times fine and 20 times getting the error above. If I stop and restart the web service on the server, everything works great again - until the next time I open and close the database. Any ideas??? Thanks!

[discostew99]

Figured out what the problem was. The Everyone group needs to have Write permissions on the directory where the Access database lives. This will also cause the database itself to have Write permissions for the Everyone group. Works like a charm now.

[discostew99]

Originally Posted by discostew99

Figured out what the problem was. The Everyone group needs to have Write permissions on the directory where the Access database lives. This will also cause the database itself to have Write permissions for the Everyone group. Works like a charm now.

UPDATE: The .mdb does not have to have Write permissions for the Everyone group - just the directory.

[selwonk]

If this folder is only going to be used by a web application, I'd avoid using the "Everyone" group and just allow write access to the Internet guest account (this begins IUSR_....) This way you keep everything nice and secure

Originally Posted by discostew99

Figured out what the problem was. The Everyone group needs to have Write permissions on the directory where the Access database lives. This will also cause the database itself to have Write permissions for the Everyone group. Works like a charm now.