I'm getting the message "Too few parameters expected."

You may encounter this message if a parameter query exported to the IDC file type doesn't have data types specified in the Query Parameters dialog box.

1. In the Database window, click Queries under Objects.
2. Click the name of the parameter query you want to modify, and click Design on the Database window toolbar.
3. Specify a data type for the parameter.

   How?

   1. On the Query menu, click Parameters.

   2. In the first Parameter cell, type the first prompt you entered in the query design grid.

   3. In the Data Type cell to the right, click the appropriate data type according to the following guidelines:

      If the parameter field data type is	Click this data type in the Data Type cell
      Currency, Date/Time, Memo, OLE Object, Text, and Yes/No	Currency, Date/Time, Memo, OLE Object, Text, and Yes/No
      Number	Byte, Single, Double, Integer, Long Integer, and Replication ID. These data types correspond to the five FieldSize property settings of the Number data type.
      Unknown	Value. This is a generic data type that accepts any type of data.
      Binary	Binary. Used with parameter queries directed to linked tables that do recognize this data type (Microsoft Access does not recognize this data type).

   4. Repeat Steps 2 and 3 for each parameter you want to specify a data type for.

4. Save and run the query.