FIX: ASP Fails to Access Network Files Under IIS 4.0

ID: Q189408


The information in this article applies to:
  • Active Server Pages
  • Microsoft ODBC Driver for Access, version 3.5
  • Microsoft Internet Information Server versions 4.0, 5.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.


In situations where Access is linked to Access tables across the network, disable password synchronization, see the following article in the Microsoft Knowledge Base:
Q180815 BUG: IIS 4 Fails When Using a UNC to Microsoft Access


STATUS

This behavior is by design. The Anonymous logon performed when Password Synchronization is enabled is a non-interactive logon which improves the performance of Anonymous logons.

This problem does not occur with IIS 5.0/Windows 2000 because changes in the security architecture ensure that noninteractive logons do not fail on network access.

Additional query words:

Keywords : kberrmsg kbADO kbASP kbWinOS2000fix kbSecurity kbWebServer kbGrpASP kbODBC350bug kbiis400bug kbiis500fix kbFSO
Version : WINDOWS:3.5; winnt:4.0,5.0
Platform : WINDOWS winnt
Issue type : kbbug


Last Reviewed: December 8, 1999
© 2000 Microsoft Corporation. All rights reserved. Terms of Use.