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

• Microsoft Access 2000

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 7.0 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.

Additional query words: prb removed

Keywords : kbdta AccDAP
Version : WINDOWS:2000
Platform : WINDOWS
Issue type : kbprb