ASP Weird Unspecified Error - 80004005

Question

Hello, 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

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

Answer 2

Have you looked here?

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

Answer 3

Check that the IUSR account has permissions on the Access database and the folders/sub-folders containing it. I've found that on occasion if you rename or compact an access database it loses IUSR priviledges so appears in use / locked

Answer 4

Whatever happened, it is resulting in an 80004005 error, so the problem is definitely a permission issue.

Depending on the configuration of the web server, it may not be the IUSR account that needs the access. I find it's best to fire up FileMon, filter it to the name of my database (with wildcards), and check out the properties of the error that shows up. Viewing the properties will show you the user that is actually trying to access the file.

For Access databases, you want to make sure that you're modifying the permissions of the folder and not the file. You'll need Modify permissions on the folder so that the .ldb file can be created.