FIX: You may receive an error message when you run a report that connects to an Access database data source in SQL Server 2000 Reporting Services (842435)


The information in this article applies to:

  • Microsoft SQL Server 2000 Reporting Services
Bug #: 107472 (SQL Server 8.0)
SQL BU Defect Tracking:107472

SYMPTOMS

When you run a report that connects to a Microsoft Access database data source and the data source is located on a shared network folder, you may receive the following error message:
The Microsoft Jet database engine cannot open the file 'Full path of the Access database file'. It is already opened exclusively by another user, or you need permission to view its data.
This problem may occur if all the following conditions are true:
  • The Windows Everyone group has Read permissions and Change permissions on the shared network folder that contains the Access database.
  • The Windows NT Integrated Security option to connect to the data source is enabled.
  • The client that you use to run the report is running on a computer other than the report server.
Note This problem does not occur if the client that you use to run the report is running on the report server.

RESOLUTION

To resolve this problem, obtain the latest service pack for Microsoft SQL Server 2000 Reporting Services. For additional information, click the following article number to view the article in the Microsoft Knowledge Base:

842440 How to obtain the latest service pack for SQL Server 2000 Reporting Services

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

This problem was first corrected in SQL Server 2000 Reporting Services Service Pack 1.

MORE INFORMATION

Steps to reproduce the problem

Note To reproduce this problem, you must have three computers. These computers are referred to as computer A, computer B, and computer C. Computer B is the report server.
  1. On computer A, copy an Access database to a folder, and then create a network share on the folder.
  2. Grant Read permissions and Write permissions to the Windows Everyone group on the network share that you created in step 1.
  3. On computer B, use Report Designer to create a report that connects to the Access database. Make sure that you use the Windows NT Integrated Security option to connect to the data source.
  4. Use Report Manager to run the report that you created in step 3.

    The report should run successfully.
  5. On computer C, use an Internet browser to open Report Manager on computer B.
  6. Locate the report that you created in step 3, and then run the report.

    You may receive the error message that is mentioned in the "Symptoms" section.
Modification Type:MinorLast Reviewed:7/7/2004
Keywords:kberrmsg kbSecurity kbAuthentication kbServer kbDatabase kbSQLServ2000RSSP1fix kbfix KB842435 kbAudDeveloper
©2004 Microsoft Corporation. All rights reserved.