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:
- Open the MMC.
- Edit the Properties page of the application.
- Under the Directory Security tab, Edit "Anonymous Access and
Authentication Control."
- Edit the "Account used for Anonymous Access:"
- 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