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


The information in this article applies to:

  • Microsoft Access 2000
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.

MORE INFORMATION

Steps to Reproduce the Behavior

  1. Open the sample database Northwind.mdb.
  2. In the Database window, click Pages under Objects, and then click New.
  3. In the New Data Access Page dialog box, click Design View, and then click OK.
  4. 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.
  5. If you are prompted to choose between Individual Controls or Pivot Table List, click Individual Controls, and then click OK.
  6. On the View menu, click Page View. Note that there are three records currently available for display on this page.
  7. On the View menu, click Design View.
  8. 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?

  9. Click Yes.
  10. On the View menu, click Page View. Note that there are no longer any records available for display on the page.
Modification Type:MajorLast Reviewed:6/24/2004
Keywords:kbDAP kbprb KB203216
©2004 Microsoft Corporation. All rights reserved.