FP2000: Using Parameter Query for Database Results Region Generates Error Message (265342)


The information in this article applies to:

  • Microsoft FrontPage 2000
This article was previously published under Q265342

SYMPTOMS

When you import a Microsoft Access 2000 database into your Microsoft FrontPage 2000 web, create a database results region and publish it to your server, and then browse the Web page that you imported the database into, you may receive an error message similar to the following:
Database Results Error Description: The application has improperly defined a Parameter object. Number: 3708 (0xE7C) Source: ADODB.Recordset

CAUSE

This behavior can occur if you attempt to use a parameter query as the record source for a database results region.

RESOLUTION

To resolve this issue, re-create the query in FrontPage. To create a query in FrontPage, follow these steps:
  1. Start FrontPage.
  2. On the File menu, click Open Web.
  3. Browse to find the web that you want, and then click Open.
  4. On the File menu, point to New, and then click Page.
  5. Click Normal Page, and then click OK.
  6. On the Insert menu, point to Database, and then click Results.
  7. Click the connection that you want (for example, click Use a sample database connection (Northwind)), and then click Next.
  8. Click Record source, select the table that you want as the record source (for example, Employees), and then click Next.
  9. Click Edit List.
  10. Press CTRL and select the fields that you do not want to be displayed (for example, Title).
  11. Click Remove, and then click OK.
  12. Click More Options.
  13. Click Criteria, and then click Add.
  14. In the Field Name box, select the field that you want to query on (for example, Address).
  15. In the Comparison box, select a comparison (for example, Contains).
  16. Click to select the Use search from field check box (if necessary).
  17. Click OK twice to return to the More Options dialog box.
  18. Click Defaults, and then click Edit.
  19. Type ? in the Value box.
  20. Click OK three times to return to the Database Results Wizard dialog box.
  21. Click Next twice, and then click Finish.
  22. On the File menu, click Save As.
  23. In the Save as type box, click Active Server Pages (*.asp).
  24. Name the file, and then click Save.
  25. On the File menu, click Publish Web.
  26. Specify the location that you want, and then click Publish.
  27. Browse to the new page, type a value into the text box, and then click Submit.
Modification Type:MajorLast Reviewed:12/2/2000
Keywords:kbprb KB265342
©2002 Microsoft Corporation. All rights reserved.