Microsoft KB Archive/313298

= ACC2002: Error Starting Query Designer from the RecordSource Property of an Access Project (ADP) Report =

Article ID: 313298

Article Last Modified on 9/25/2003

-

APPLIES TO


 * Microsoft Access 2002 Standard Edition

-



This article was previously published under Q313298



Advanced: Requires expert coding, interoperability, and multiuser skills.

This article applies only to a Microsoft Access project (.adp).



SYMPTOMS
When you try to start the Query Designer by clicking the Build (...) button next to the RecordSource property of a report, you receive the following error message:

This version of Microsoft Access doesn't support design changes to the version of Microsoft SQL Server your project is connected to. See the Microsoft Office Update Web site for the latest information and downloads (on the Help menu, click Office on the Web). Your design changes will not be saved.



CAUSE
You do not have Execute permission to the dt_verstamp007 system stored procedure in the SQL Server database. Microsoft Access relies on this stored procedure when it performs some types of actions in the database.



RESOLUTION
Grant the user (or the Public database role) EXECUTE permission on the dt_verstamp007 system stored procedure in the database.



MORE INFORMATION
For more information about handling SQL Server security, please see to the SQL Server security articles on the following Microsoft Web site:

SQL Server 2000 Security

SQL Server 7.0 Security

Steps to Reproduce the Behavior
Use SQL Server 2000 Enterprise Manager to follow these steps:
 * 1) Create a new user and grant access to the sample database NorthwindCS.adp. Do not grant the new user any object permissions or make it a member of any Server or database role other than the NorthwindCS Public database role.
 * 2) Remove Execute permission to the dt_verstamp007 stored procedure for the Public Database role in NorthwindCS.
 * 3) Open NorthwindCS.adp, and then connect it to the same NorthwindCS database from step 1. Use the security credentials of the newly created user.
 * 4) Close the startup form, if it opens.
 * 5) In the Database window, open the Invoice report in Design view.
 * 6) Open the property sheet for the report, and then click the Build (...) button next to the RecordSource property to start the Query Designer.

Note that you receive the error message that is mentioned in the &quot;Symptoms&quot; section of this article.

Additional query words: prb

Keywords: kberrmsg kbprb KB313298

-

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

© Microsoft Corporation. All rights reserved.