ACC2002: Stored Procedure Is Not Found When Run from Editor (287462)


The information in this article applies to:

  • Microsoft Access 2002
This article was previously published under Q287462
Moderate: Requires basic macro, coding, and interoperability skills.

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

SYMPTOMS

When you modify an existing stored procedure, save the changes, and then attempt to run the procedure, you receive the following error message:
Could not find stored procedure 'stored procedure name'.

CAUSE

This behavior occurs because Microsoft Access incorrectly modifies the name of the stored procedure after it is edited and saved.

RESOLUTION

To work around this issue, close the SQL Text Editor and run the stored procedure from the Database window.

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

MORE INFORMATION

Steps to Reproduce the Problem

  1. Open the sample Access project NorthwindCS.adp.
  2. Open the Ten Most Expensive Products stored procedure in Design view in the SQL Text Editor.
  3. Modify the stored procedure by changing the name to New Ten Most Expensive Products.
  4. On the File menu, click Save.
  5. On the Query menu, click Run. You receive the error message described in the "Symptoms" section.

REFERENCES

For more information about stored procedures, click Microsoft Access Help on the Help menu, type stored procedures in the Office Assistant or the Answer Wizard, and then click Search to view the topics returned.
Modification Type:MajorLast Reviewed:11/6/2003
Keywords:kbbug kberrmsg KB287462
©2003 Microsoft Corporation. All rights reserved.