ACC2000: Syntax Error When You Export a Parameter Query to Active Server Page (ASP) Format

When you export a Microsoft Access parameter query in the Active Server Page (ASP) format and then view the ASP page from a browser, you may receive an error message similar to the following: where the expected syntax would have been:

When the query is saved to ASP, two files are generated: one in ASP format, the other in HTML format. The parameter is written to both, but in the ASP file, the parameter portion that references Request.QueryString has been incorrectly parsed.

Further, if the query is re-exported to the same name, Access requests to overwrite the ASP file, but does not overwrite the HTML file. This results in a mismatch with Request.QueryString.

For example, in a query that is based on the Customer table in the sample database Northwind.mdb, the SQL statement might read: When you export the query to ASP format, the syntax becomes:

To get the correct result, use Notepad or an HTML editor to correct the syntax. For example, in the "Steps to Reproduce the Behavior" section later in this article, the following syntax is generated when the query is exported: Edit the SQL statement to read as follows:

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

Note that in the generated SQL statement, the string delimiters (apostrophes) are missing because Access does not take the data type into consideration when it exports the query. If the string delimiters are omitted from the SQL statement, you receive the following error when you view the ASP page:

Steps to Reproduce the Behavior

1. On a Web server that has the ASP components installed, create a System DSN that points to a copy of the sample database Northwind.mdb.
2. Open the database that the DSN points to.
3. Create the following query based on the Customers table, and then save it as qryAsp:

      Query: qryAsp
      --------------------------------
      Type: Select Query
   
      Field: CustomerID
      Table: Customers
      Criteria: "=[Enter Customer ID]"
   
      Field: CompanyName
      Table: Customers
   
      Field: ContactName
      Table: Customers
   					

4. Close the query, and then ensure that it is selected in the Database window.
5. On the File menu, click Export.
6. In the Export Query 'qryASP' To dialog box, change the Save as type box to Microsoft Active Server Pages (*.asp).
7. Save the file as qryAsp.asp in a Web folder on the Web server.
8. Use a Web browser to view the file. Note that you receive the error message that is mentioned in the "Symptoms" section.