Microsoft KB Archive/287471

= ACC2002: &quot;Action&quot; Stored Procedures Appear in Page Wizard =

Article ID: 287471

Article Last Modified on 11/5/2003

-

APPLIES TO


 * Microsoft Access 2002 Standard Edition

-



This article was previously published under Q287471



Moderate: Requires basic macro, coding, and interoperability skills.

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



SYMPTOMS
When you create a data access page, you may notice that stored procedures appear in the list of tables and queries in the New Data Access Page dialog box as well as in the Page Wizard. If you select one of these procedures when you use the wizard, there are no available fields to select from and clicking Next returns the following error message:

You must select fields for the page before you can continue.



CAUSE
Not all stored procedures can be used to create a data access page. Stored procedures can also be used to carry out actions such as inserting or updating or deleting data, or creating tables. These procedures do not return results that can be used by a page. Stored procedures that do not return results may contain the following SQL statements:


 * INSERT INTO
 * DELETE...FROM
 * UPDATE...SET
 * CREATE TABLE



RESOLUTION
With a data access page, choose a stored procedure that returns records with fields.



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 Behavior
 Start Microsoft Access, and then the open the sample project NorthwindCS.adp. In the Database window, click Queries under Objects, and then click New. In the New Query dialog box, click Create Text Stored Procedure, and then click OK.  Type the following script into the SQL Text Editor: CREATE PROCEDURE spCreateTable

AS  CREATE TABLE TestTable (      MyPK int IDENTITY (1,1),       FirstName char(20),       LastName char(20)   )  Close and save the stored procedure.</li> In the Database window, click Pages under Objects, and then click New.</li> In the New Data Access Page dialog box, click Page Wizard, and then click OK.</li> Click spCreateTable in the Tables/Queries list, and then click Next.</li></ol>

Note that there are no available fields, that the wizard does not continue, and that you receive the error message that is mentioned in the &quot;Symptoms&quot; section of this article.

Additional query words: pra

Keywords: kberrmsg kbbug KB287471

-

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

© Microsoft Corporation. All rights reserved.