first_page the funky knowledge base
personal notes from way, _way_ back and maybe today

ASP, ADO and Microsoft Access PROBLEM: Access MDB File Fails to Open or Appears Locked

The IIS user account (e.g. IUSR_<machine name>) requires dangerously high levels of security permissions to open Access MDB files via ASP. When it cannot open the Access database this error may be thrown:

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 will not recommend what should be done in response to this problem as using Access databases behind any serious web site totally sucks in ways thought not suckable. Microsoft, alternatively, has more details (MS KB article Q174943):

http://support.microsoft.com/support/kb/articles/q174/9/43.asp
mod date: 2001-10-29T02:23:53.000Z