Microsoft KB Archive/287462

= ACC2002: Stored Procedure Is Not Found When Run from Editor =

Article ID: 287462

Article Last Modified on 11/6/2003

-

APPLIES TO


 * Microsoft Access 2002 Standard Edition

-



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 ' '.



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.



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

