Microsoft Knowledge Base Email Alertz

(189408) - Failures occur when Active Server Pages (ASP) code accesses a file-based resource over the network. Examples include the following: If you Scripting.FileSystemObject to access a file that is stored on a network share, you receive the following error...

Search KbAlertz

Advanced Search

Receive Microsoft Knowledge Base articles by E-Mail?

Every night we scan the Microsoft Knowledge Base. If technologies you're interested in are updated, we'll send you an e-mail. You only get one e-mail a day, and only when new articles are added.

Click here to create a
FREE account
Already have an account?
[Click here to Login]











Microsoft Knowledge Base Article

This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved. Terms of Use | Trademarks

Article ID: 189408 - Last Review: July 8, 2005 - Revision: 4.5

FIX: ASP Fails to Access Network Files Under IIS 4.0 and IIS 5.0

This article was previously published under Q189408

SYMPTOMS

Failures occur when Active Server Pages (ASP) code accesses a file-based resource over the network. Examples include the following:
  • If you Scripting.FileSystemObject to access a file that is stored on a network share, you receive the following error message:
    Server object error 'ASP 0177:800a0046'
    Server.CreateObject Failed
    ...
    The operation completed successfully.
  • If you access a local Microsoft Access database that is linked to a table where the table linked to is in an Access database on a network server, you receive 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 '******'. 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. For IIS 5.0, password synchronization is called "Allow IIS to control password."

When you connect to an Access database or that Access database is linked to Access tables across the network, this problem can be caused by a combination of password synchronization being enabled and a bug in the Odbcjt32.dll version 3.51.1029 (Microsoft Data Access Components 1.5). That particular problem has been fixed in MDAC version 2.0 and later.

RESOLUTION

Disable password synchronization for the Internet Information Server 4.0 application. For IIS 5.0, do not allow IIS to control the password. To do this, perform the following steps:
  1. Open the Internet Services Manager.
  2. Edit the Properties of the application.
  3. On the Directory Security tab, edit Anonymous Access and Authentication Control.
  4. Edit the Account used for Anonymous Access.
  5. In IIS 4.0, clear the Enable Automatic Password Synchronization check box.

    In IIS 5.0, clear the Allow IIS to control password check box.

STATUS

This behavior is by design.

This problem does not occur for IIS 5.0/Windows 2000 networks that are set up to use Kerberos authentication.

REFERENCES

For additional information, click the article number below to view the article in the Microsoft Knowledge Base:
229694  (http://kbalertz.com/Feedback.aspx?kbNumber=229694/EN-US/ ) How to Use the IIS Security What If Tool

APPLIES TO
  • Microsoft Active Server Pages 2.0
  • Microsoft Active Server Pages 3.0
  • Microsoft Open Database Connectivity Driver for Access 3.5
  • Microsoft Internet Information Server 4.0
  • Microsoft Internet Information Services 5.0
  • Microsoft Data Access Components 2.5
  • Microsoft Data Access Components 2.6
  • Microsoft Data Access Components 2.7
Keywords: 
kbbug kbdatabase kberrmsg kbfix kbiis500fix kboswin2000fix kbsecurity kbwebserver KB189408
       

Community Feedback System

Very often, it takes hours to solve a problem. Very often, you've looked high and low, and have tried a lot of solutions. When you finally found it, chances are, it was because someone else helped you. Here's your chance to give back. Use our community feedback tool to let others know what worked for you and what didn't.

Please also understand that the community feedback system is not warranted to be correct, it's simply a system that we've built to let people try and help each other. If something in a feedback response doesn't make sense to you, or you're not comfortable making changes that the feedback talks about (like registry edits), please consult a professional.

Thank you for using kbAlertz.com Feedback System.

-- Scott Cate