PRB: Cannot Open File Unknown Using Access

• Active Server Pages
• Microsoft Internet Information Server versions 4.0, 5.0

SYMPTOMS

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

CAUSE

This Error message can be caused by any of the following conditions:

1. The Access .mdb file is located on another computer than the IIS Server.
   
   -and-
   
   IIS Server is configured to use NT Challenge / Response when accessing secured script files.



2. The Access .mdb file is located on another computer than the computer running IIS.
   
   -and-
   
   IIS is configured to use the IUSR_computername account for anonymous access.
   
   -and-
   
   The script file being accessed is not secured and permits anonymous access.
   
   -and-
   
   The IUSR_computername is a local account and the same account/password does not exist on the remote computer



3. The Access .mdb file is located on another computer than the computer running IIS.
   
   -and-
   
   IIS is configured to use Basic (Clear Text) authentication when accessing secured script files.



4. The Access .mdb file is located on the same computer as the Web server.
   
   -and-
   
   The datasource uses a UNC path to point to the .mdb file (for example, DSN=\\servername\share).
   
   -and-
   
   NT Challenge/Response is used to authenticate the user.



5. The Access .mdb file is linked to a table where the table linked to is in an Access database on a network server. In this situation, please refer to the following article in the Knowledge Base for a workaround:

   Q189408 PRB: ASP Fails to Access Network Files Under IIS 4.0

RESOLUTION

This bug has been fixed in the 2.0 release of Microsoft Data Access Components. Upgrade to version 2.0 of the Microsoft Data Access Components to access a database on a remote machine.

MORE INFORMATION

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.

REFERENCES

For additional information, please see the following article in the Microsoft Knowledge Base:

Q174811 FILE: Authentication and Security for Internet Developers

Additional query words:

Keywords : kbsetup kbtshoot kbAccess kbADO kbASP kbASPObj kbSecurity kbGrpASP kbiis400 kbiis500
Version : winnt:
Platform : winnt
Issue type : kbprb