Microsoft KB Archive/207143

= ACC2000: Access Data Produces "Too Few Parameters" Error in Microsoft Query =

Article ID: 207143

Article Last Modified on 6/24/2004

-

APPLIES TO


 * Microsoft Access 2000 Standard Edition
 * Microsoft Query 2000

-



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.

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.



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.

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

[Enter a Product Name]

 Save and close the query. Quit Microsoft Access. Start Microsoft Query.</li> On the File menu, click New.</li> In the Choose Data Source dialog box, click MS Access Database, and then click OK.</li> In the Select Database dialog box, locate the sample database Northwind.mdb, select it, and then click OK.</li> 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.</li> Click Next twice, and then click Finish. Notice that you receive the following error message:

Too few parameters. Expected 1.

</li></ol>

<div class="references_section">