Article ID: 171850 - View products that this article applies to.
This article was previously published under Q171850
When you create a parameter query based on a Microsoft Access database in Microsoft 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,
This error was returned by the driver. For more information, check the Documentation for the driver you are currently using.
This error can occur under the following circumstances:
This 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.
Parameter Specified in Microsoft Query Version 2.0Although the prompt for criteria is not available in Microsoft Query version 2.0, you can click Criteria on the View menu, and then change the contents of the Criteria field's Value row to view different query results.
Parameter Specified in Microsoft AccessIn 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 a Microsoft Excel file from within Microsoft Access.
Steps to Reproduce Behavior
Example 1: Parameter Query Created in Microsoft Query
Example 2: Parameter Query Created in Microsoft Access
For more information about parameters, search the Microsoft Access Help Index for "parameter queries."
For more information about make-table queries, search the Microsoft Access Help Index for "make-table queries, creating," and then display the topic "Create a new table from the results of a query with a make-table query."
For more information about exporting data from Microsoft Access to Microsoft Excel, search the Microsoft Access Help Index for "Excel, exporting Microsoft Access data to Microsoft Excel," and then display the topic "Export a table or query to a spreadsheet."
Article ID: 171850 - Last Review: January 20, 2007 - Revision: 4.1
Retired KB Content Disclaimer
This article was written about products for which Microsoft no longer offers support. Therefore, this article is offered "as is" and will no longer be updated.