ACC2000: Access Data Produces "Too Few Parameters" Error in Microsoft Query (207143)


The information in this article applies to:

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

This article applies only to a Microsoft Access database (.mdb).

SYMPTOMS

When you create a query in Microsoft Query based on a Microsoft Access parameter query, you may receive the following error message:
Too few parameters. Expected n.
If you click Help in the error message box, the topic states,

Driver error.
This error was returned by the driver. For more information, check the documentation for the driver you are currently using.

CAUSE

This behavior is a limitation of the Microsoft Access ODBC driver. Prompting for query parameters is a functionality of the Microsoft Access user interface. However, the Microsoft Access ODBC driver doesn't have this capability; therefore, it generates an error message.

RESOLUTION

In Microsoft Access, create a make-table query based on the parameter query; run the make-table query, and then use the resulting table in Microsoft Query.

If you are using Microsoft Query to make the results of a Microsoft Access parameter query available to Microsoft Excel, you may want to consider exporting the parameter query to an Excel file from within Access.

MORE INFORMATION

Steps to Reproduce Behavior

CAUTION: If you follow the steps in this example, you modify the sample database Northwind.mdb. You may want to back up the Northwind.mdb file and follow these steps on a copy of the database.

  1. Start Microsoft Access and open the sample database Northwind.mdb.
  2. Open the Current Product List query in Design view.
  3. In the Criteria row of the ProductName field, type the following:

    [Enter a Product Name]

  4. Save and close the query. Quit Microsoft Access.
  5. Start Microsoft Query.
  6. On the File menu, click New.
  7. In the Choose Data Source dialog box, click MS Access Database, and then click OK.
  8. In the Select Database dialog box, locate the sample database Northwind.mdb, select it, and then click OK.
  9. In the Query Wizard - Choose Columns dialog box, select Current Product List, and then click > (right arrow) to select ProductID and ProductName as columns in your query.
  10. Click Next twice, and then click Finish. Notice that you receive the following error message:
    Too few parameters. Expected 1.

REFERENCES

For more information about parameter queries, click Microsoft Access Help on the Help menu, type what is a parameter query and when would you use one? in the Office Assistant or the Answer Wizard, and then click Search to view the topic.

For more information about make-table queries, click Microsoft Access Help on the Help menu, type create a new table from the results of a query with a make-table query in the Office Assistant or the Answer Wizard, and then click Search to view the topic.

For more information about exporting data from Microsoft Access toMicrosoft Excel, click Microsoft Access Help on the Help menu, type load the output of a datasheet, form, or report into microsoft excel in the Office Assistant or the Answer Wizard, and then click Search to view the topic.
Modification Type:MajorLast Reviewed:6/24/2004
Keywords:kberrmsg kbinterop kbprb KB207143
©2004 Microsoft Corporation. All rights reserved.