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!