ACC2002: Error When You Save a Form or a Report as a Data Access Page (293357)


The information in this article applies to:

  • Microsoft Access 2002
This article was previously published under Q293357
Novice: Requires knowledge of the user interface on single-user computers.

This article applies to a Microsoft Access database (.mdb) and to a Microsoft Access project (.adp).

SYMPTOMS

When you save a form or a report as a data access page in a Microsoft Access project (ADP) file or a Microsoft Access database (MDB) file, you receive the following error message:

Microsoft Access is unable to create the data access page.

The file you attempted to load was not recognized as HTML.

You may have selected the wrong file, or tried to open a database file off of a web server.

CAUSE

The form or the report contains a combo box or a list box control whose RowSource property is set to the name of a table, a view, or a function.

RESOLUTION

Set the RowSource property to the name of a stored procedure or an SQL SELECT statement that selects the proper fields. Then save the form or the report as a data access page.

STATUS

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

MORE INFORMATION

CAUTION: If you follow the steps in this example, you modify the sample Access project NorthwindCS.adp. You may want to back up the NorthwindCS.adp file and follow these steps on a copy of the project.

Steps to Reproduce the Behavior

  1. Open the sample project NorthwindCS.adp or the sample database Northwind.mdb.
  2. Close the Main Switchboard form, if it appears.
  3. On the View menu, point to Database Objects, and then click Forms.
  4. In the Database window, click the Products form, and then click Design.
  5. Click the SupplierID combo box to select it.
  6. On the View menu, click Properties to view the property sheet for the SupplierID combo box.
  7. Click the Data tab.

    Note that the RowSource property of the combo box is set to an SQL SELECT statement.
  8. Change the RowSource property to Suppliers.
  9. On the File menu, click Save.
  10. On the View menu, click Form View.
  11. Click the arrow in the SupplierID combo box, and then verify that the list contains values.
  12. Close the form.
  13. In the Database window, click the Products form.
  14. On the File menu, click Save as.
  15. In the Save Form to box, type Products, click the arrow in the As box, click Data Access Page, and then click OK.
  16. Enter a destination file name when you are prompted, and then click OK.

    You receive the following error message:

    Microsoft Access is unable to create the data access page. The file you attempted to load was not recognized as HTML. You may have selected the wrong file, or tried to open a database file off of a web server.
Modification Type:MinorLast Reviewed:9/27/2006
Keywords:kbbug kberrmsg kbnofix KB293357 kbAudDeveloper
©2004 Microsoft Corporation. All rights reserved.