PRB: ASP Fails to Access Network Files Under IIS 4.0

• Active Server Pages
• Microsoft ODBC Driver for Access, version 3.5
• Microsoft Internet Information Server version 4.0

SYMPTOMS

Failures occur when Active Server Pages (ASP) code accesses a file-based resource over the network. Examples would include the following:

• Using the Scripting.FileSystemObject to access a file stored on a network share. Here is the resulting error message:
  

  Server object error 'ASP 0177:800a0046'
  Server.CreateObject Failed
  ...
  The operation completed successfully.




• Accessing a local Microsoft Access database linked to a table where the table linked to is in an Access database on a network server. Here is the resulting 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 '******'. It is already opened
  exclusively by another user, or you need permission to view its data.

CAUSE

This behavior occurs when password synchronization is enabled for the IIS 4.0 application.

In situations where Access is linked to Access tables across the network, this is caused by a combination of password synchronization being enabled and a bug in the Odbcjt32.dll version 3.51.1029.

RESOLUTION

Disable password synchronization for the Internet Information Server 4.0 application. Use the following steps to disable password synchronization:

1. Open the MMC.



2. Edit the Properties page of the application.



3. Under the Directory Security tab, Edit "Anonymous Access and Authentication Control."



4. Edit the "Account used for Anonymous Access:"



5. Clear the "Enable Automatic Password Synchronization" check box.

Q180815 BUG: IIS 4 Fails When Using a UNC to Microsoft Access

STATUS

Microsoft has confirmed this to be a bug in the Microsoft products listed at the beginning of this article.

Additional query words:

Keywords          : kberrmsg kbADO kbASP kbASPObj kbInternet kbSecurity kbWebServer kbGrpASP 
Version           : WINDOWS:3.5; winnt:4.0
Platform          : WINDOWS winnt 
Issue type        : kbprb 

Last Reviewed: May 27, 1999