ASP Weird Unspecified Error - 80004005

Question

I had to work on an already made website, just adding some small module

While i was updating, there was many files called myDB.mdb in the different subfolders i wanted to make sure that my app is connecting the right database so i started renaming subfolder...at one of those subfolders, i refreshed,the main site and mine stopped working

i renamed back to the correct name.. refresh... refresh... refresh.. i am still refreshing and i started another browser.. it is giving a connection problem :S

Provider error '80004005'

Unspecified error

/new/conn.asp, line 13

any idea about his :S would appreciate any help !

Answer 1

I have had the same problem. The first time I loaded a page it worked well, but if I loaded the page again quickly, then I got this error. If I waited for a while then I didn't get the error. It must be because when you call objConnection.Close it takes some time to actually close the mdb file, so if you try and open it again you get the "File already in use type error". Strangely adding a mode to the connection sorted this problem out for me. It doesn't have to be read only, read / write works as well.

objConnection.Mode = 1 ' read only

Answer 2

Microsoft OLE DB Provider for ODBC Drivers error '80004005' [Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine cannot open the file '(unknown)'. It is already opened exclusively by another user, or you need permission to view its data.

or

Microsoft OLE DB Provider for ODBC Drivers (0x80004005) [Microsoft][ODBC Microsoft Access Driver] '(unknown)' isn't a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides.

or

Microsoft OLE DB Provider for ODBC Drivers error '80004005' [Microsoft][ODBC Microsoft Access 97 Driver] Couldn't use '(unknown)'; file already in use.

From: http://tutorials.aspfaq.com/8000xxxxx-errors/80004005-errors.html