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


The information in this article applies to:

  • Microsoft Access 2002
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 "Symptoms" section of this article.
Modification Type:MajorLast Reviewed:9/25/2003
Keywords:kberrmsg kbprb KB313298
©2003 Microsoft Corporation. All rights reserved.