Microsoft KB Archive/293357

= ACC2002: Error When You Save a Form or a Report as a Data Access Page =

Article ID: 293357

Article Last Modified on 9/27/2006

-

APPLIES TO


 * Microsoft Access 2002 Standard Edition

-



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
 Open the sample project NorthwindCS.adp or the sample database Northwind.mdb. Close the Main Switchboard form, if it appears. On the View menu, point to Database Objects, and then click Forms. In the Database window, click the Products form, and then click Design.</li> Click the SupplierID combo box to select it.</li> On the View menu, click Properties to view the property sheet for the SupplierID combo box.</li> Click the Data tab.

Note that the RowSource property of the combo box is set to an SQL SELECT statement.</li> Change the RowSource property to Suppliers .</li> On the File menu, click Save.</li> On the View menu, click Form View.</li> Click the arrow in the SupplierID combo box, and then verify that the list contains values.</li> Close the form.</li> In the Database window, click the Products form.</li> On the File menu, click Save as.</li> In the Save Form to box, type Products, click the arrow in the As box, click Data Access Page, and then click OK.</li> 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.

</li></ol>

Additional query words: pra OfficeErrorMessages 10012

Keywords: kbbug kberrmsg kbnofix KB293357

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.