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