Microsoft KB Archive/203216

= ACC2000: A Data Access Page That Does Not Have a 2-D Section Cannot Be Bound =

Article ID: 203216

Article Last Modified on 6/24/2004

-

APPLIES TO


 * Microsoft Access 2000 Standard Edition

-



This article was previously published under Q203216



Moderate: Requires basic macro, coding, and interoperability skills.

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



SYMPTOMS
When you delete the 2-D, or grid section, of a data access page, you can no longer bind the page to a data source. Additionally, after you have removed the 2-D section, you cannot replace it on the page.



CAUSE
When you delete the 2-D section of the page, the Microsoft Office Data Source control is also removed. The Microsoft Office Data Source control is required to bind a page to any data source.



RESOLUTION
You cannot add the Microsoft Office Data Source control back to the page after you have deleted the control. If you have deleted the control from your page, you must rebuild the page.



Steps to Reproduce the Behavior
 Open the sample database Northwind.mdb. In the Database window, click Pages under Objects, and then click New. In the New Data Access Page dialog box, click Design View, and then click OK. If the field list is not displayed, click Field List on the View menu. Then, drag the Shippers table from the field list to the section of the page that is labeled Click here and type title text. If you are prompted to choose between Individual Controls or Pivot Table List, click Individual Controls, and then click OK.</li> On the View menu, click Page View. Note that there are three records currently available for display on this page.</li> On the View menu, click Design View.</li> Select the section of the page that is labeled Header: Shippers, and then delete it. You are prompted with the following message:

You are about to delete this section and all related sections.

If you click Yes, the controls you placed in these sections will be deleted and you won't be able to undo this operation.

Are you sure you want to delete these controls?

</li> Click Yes.</li> On the View menu, click Page View. Note that there are no longer any records available for display on the page.</li></ol>

Additional query words: inf prb

Keywords: kbdap kbprb KB203216

-

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

© Microsoft Corporation. All rights reserved.