Article ID: 166029 - View products that this article applies to.
This article was previously published under Q166029
We strongly recommend that all users upgrade to Microsoft Internet Information Services (IIS) version 7.0 running on Microsoft Windows Server 2008. IIS 7.0 significantly increases Web infrastructure security. For more information about IIS security-related topics, visit the following Microsoft Web site:
http://www.microsoft.com/technet/security/prodtech/IIS.mspxFor more information about IIS 7.0, visit the following Microsoft Web site:
When using Active Server Pages (ASP) to query an Access database, you may encounter the following error message.
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Microsoft Access 97 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.
/scripts/somefile.asp, line x
This Error message can be caused by any of the following conditions:
When using NT Challenge / Response with IIS, the users credentials are created at the browser. The credentials are then sent to IIS. IIS cannot forward those credentials on to another server.
The connection is attempted, but there is no username specified when connecting to the remote machine, so the connection fails.
For additional information, click the article numbers below to view the articles in the Microsoft Knowledge Base:
(http://support.microsoft.com/kb/174811/EN-US/ )Authentication and Security White Paper for Internet Developers
(http://support.microsoft.com/kb/253580/EN-US/ )HOWTO: Connect to a Remote Access Database from Active Server Pages