Microsoft KB Archive/842435

= 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 =

Article ID: 842435

Article Last Modified on 7/7/2004

-

APPLIES TO


 * Microsoft SQL Server 2000 Reporting Services

-



Bug #: 107472 (SQL Server 8.0)



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 &quot;Applies to&quot; section.

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



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.
 * 1) On computer C, use an Internet browser to open Report Manager on computer B.
 * 2) 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 &quot;Symptoms&quot; section.

Keywords: kberrmsg kbfix kbserver kbdatabase kbsecurity kbauthentication kbsqlserv2000rssp1fix KB842435

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.