ACC2000: "Too Few Parameters" Error Occurs on ASP with Parameter in Subquery

MORE INFORMATION

Steps to Reproduce Behavior

1. On your Web Server, create a System DSN (using the Microsoft Access ODBC driver) based on the sample database Northwind.mdb, and name the data source NWind2000.
2. Start Microsoft Access and open the sample database Northwind.mdb.
3. Create the following query based on the Customers table:

   Field: CustomerID
   Table: Customers
   Criteria: [Enter Customer ID]
   
   Field: CompanyName
   Table: Customers

4. On the Query menu, click Parameters. Type the following in the Query Parameters dialog box, and then click OK:

   Parameter: [Enter Customer ID]
   Data Type: Text

5. Save this query as SubQuery.
6. Create the following query based on the SubQuery query:

   Field: CompanyName
   Table: SubQuery

7. Save this query as MainQuery.
8. On the File menu, click Export.
9. In the Save as type box, select Microsoft Active Server Pages (*.asp).
10. In the Save in box, select a folder on your Web server. The File name box should display the query name, in this case, MainQuery. Click Save.
11. In the Microsoft Active Server Pages Output Options dialog box, type NWind2000 in the Data Source Name box. In the Server URL box, type the URL of your server, and then click OK.
12. In the Enter Parameter Value dialog box that appears, simply click OK.
13. Close the query. Access creates two files: MainQuery.asp and MainQuery.html. Open MainQuery.html from Internet Explorer and type ALFKI in the Enter Customer Id box. Click Run Query.