Article ID: 207143 - Last Review: June 24, 2004 - Revision: 2.0 ACC2000: Access Data Produces "Too Few Parameters" Error in Microsoft QueryThis article was previously published under Q207143 Moderate: Requires basic macro, coding, and interoperability skills.
This article applies only to a Microsoft Access database (.mdb). On This PageSYMPTOMS
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.
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 INFORMATIONSteps to Reproduce BehaviorCAUTION: 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.
REFERENCESFor 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.
| Article Translations
|

Back to the top
