ACC2000: Relationship Dialog Box Is Displayed for Blank Data Access Page (203068)


The information in this article applies to:

  • Microsoft Access 2000
This article was previously published under Q203068
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

You are making changes to a data access page, and even though you have deleted all of the previously added controls from the data access page, you still see the New Relationship dialog box when you try to add a new field to the page.

CAUSE

Previously added controls have bound the section to a data source. Even if you remove all controls that you added previously in Design view, Access does not "unbind" the section. Consequently, if you add a new field to the section, you may see the New Relationship dialog box.

RESOLUTION

Manually unbind the section. To do so, follow these steps:
  1. If the field list is not displayed, on the View menu, click Field List.
  2. In the Field List dialog box, click the Page tab. Note the tree of objects with the name of your page at the top of the tree.
  3. Select all items beneath the page name, and then delete them.

MORE INFORMATION

Steps to Reproduce Behavior

  1. Create a new Access database.
  2. Create two linked tables to the authors and sales tables in the SQL Server sample database pubs.
  3. Click Pages under Objects, click New, and then click Design View. Click OK.
  4. Drag the authors table from the field list to the data access page. If the Design Layout dialog box appears, click Pivot Table List. Click OK.
  5. Drag the sales table from the field list to the data access page. Click Pivot Table List if necessary, and then click OK.
  6. Drag the au_lname field from the authors table to the data access page.
  7. Delete both pivot tables and the au_lname field from the data access page. Nothing should remain on the data access page.
  8. Add the stor_id field from the sales table to the data access page.
Note that the New Relationship dialog box is displayed, which indicates the presence of other controls even though you deleted all other controls from the data access page.
Modification Type:MajorLast Reviewed:6/29/2004
Keywords:kbDAP kbprb KB203068
©2004 Microsoft Corporation. All rights reserved.