ASP Can't read Database After Compact & Repair
Posted on 2002-03-07
After I compacted Access Database, the ASP Page give the following error message:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[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.
I didn't get any error during compacting database, and I can open and access the database with MS Access directly.
Moreover, I have provides password correctly in ASP Code. (I didn't change anything in my code)