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

• 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