ACC2002: "Action" Stored Procedures Appear in Page Wizard (287471)


The information in this article applies to:

  • Microsoft Access 2002
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.

MORE INFORMATION

Steps to Reproduce the Behavior

  1. Start Microsoft Access, and then the open the sample project NorthwindCS.adp.
  2. In the Database window, click Queries under Objects, and then click New.
  3. In the New Query dialog box, click Create Text Stored Procedure, and then click OK.
  4. 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)
   )
  5. Close and save the stored procedure.
  6. In the Database window, click Pages under Objects, and then click New.
  7. In the New Data Access Page dialog box, click Page Wizard, and then click OK.
  8. Click spCreateTable in the Tables/Queries list, and then click Next.
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 "Symptoms" section of this article.
Modification Type:MajorLast Reviewed:11/5/2003
Keywords:kbbug kberrmsg KB287471
©2003 Microsoft Corporation. All rights reserved.