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

Last reviewed: March 13, 1998
Article ID: Q180815
The information in this article applies to:
  • ActiveX Data Objects (ADO), version 1.5
  • Microsoft Internet Information Server version 4.0

SYMPTOMS

When connecting to a remote Microsoft Access database under Internet Information Server 4.0 (IIS) using either a Universal Naming Convention (UNC) such as \\ComputerName\ShareName or a mapped drive, the following error may appear:

   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.

RESOLUTION

To work around this problem use one of the following three methods:

  • Place the Microsoft Access .mdb file locally. This is the best solution because it provides the best performance.
  • Run the application in a separate memory space (isolated process). This does not work for some people due to configuration issues.
  • Replace the Odbcjt32.dll file with the older version 3.5 or earlier. This file can be located on the Visual Studio CD, under the setup. This option is not desirable because of performance issues.

STATUS

Microsoft has confirmed this to be a bug in the Microsoft products listed at the beginning of this article. We are researching this bug and will post new information here in the Microsoft Knowledge Base as it becomes available.

MORE INFORMATION

Steps to Reproduce Behavior

  1. Share out the Advworks.mdb from a computer (referred to here as Computer1), under the share name: TestUnc.

  2. Create a new System DSN named TestUnc on the Web server that points to the Advworks.mdb under the new share on Computer 1(\\Computer1\TestUnc).

  3. On the Web server, create an Active Server Pages (ASP) page that includes the following code:

          <%
          Set oConn = Server.CreateObject("ADODB.Connection")
          oConn.Open "TestUnc"
          %>
    

  4. Open the new ASP page from the browser, and you will see this error:

          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.
    

Keywords          : adoiis
Version           : WINDOWS:1.5; WINNT:4.0
Platform          : WINDOWS winnt
Issue type        : kbbug
Solution Type     : kbpending


================================================================================


THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: March 13, 1998
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.