ACC2000: PivotTable Loses Connection to Data After You Demote Section (200187)



The information in this article applies to:

  • Microsoft Access 2000

This article was previously published under Q200187
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

The Office PivotTable becomes disconnected from its data source immediately after you demote a section of a data access page that includes the PivotTable control.

RESOLUTION

Switch the data access page to Page view to rebind the PivotTable to its data source.

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

MORE INFORMATION

If you have designed a data access page with a grouped section, and the section includes a PivotTable control, the PivotTable control will immediately lose its connection to its data source if you choose to demote the section.

Steps to Reproduce the Behavior

  1. Open the sample database Northwind.mdb or the sample Access project NorthwindCS.adp.
  2. In the Database windows, click Pages under Objects, and then click New. Click Design View, select the Orders table from the drop-down list, and then click OK.
  3. If the field list is not displayed, click Field List on the View menu.
  4. Drag OrderID field from the Orders table from the field list into the Section: Unbound section of the data access page.
  5. Drag the CustomerID field from the same table into the Header: Orders section of the data access page.
  6. With focus still on the CustomerID text box, click the Promote button on the toolbar.
  7. Click the Header: Orders-CustomerID bar and on the Insert menu, click Office PivotTable.
  8. With focus still on the PivotTable control, click Properties on the View menu. In the property sheet, click the Format tab, and then set the following two properties of the PivotTable control:
       Height: 3in
       Left: 3in
    					
  9. If the diagonal hash marks do not appear around the PivotTable control, click the control until the hash marks appear.
  10. Right-click the PivotTable control, and then click Property Toolbox.
  11. Expand Data Source, and select Orders from the Data Member list.
  12. Close the PivotTable Property Toolbox, and then drag the following fields from the Orders table onto the respective sections of the PivotTable:

    FieldSection
    ShipCountryDrop Filter Fields Here
    EmployeeIDDrop Column Fields Here
    ShipNameDrop Row Fields Here
    FreightDrop Totals or Detail Fields Here
  13. Note that the PivotTable is properly bound without you having to switch to Page view. Right-click the CustomerID text box or the PivotTable control, and then click Demote. Note that the PivotTable control immediately displays: Unable to connect to data.

Modification Type:MajorLast Reviewed:6/24/2004
Keywords:kbbug kbDAP kbpending KB200187