ACC2002: Changing the Data Type of Any Field in a Table Resets the PivotTable View (295212)


The information in this article applies to:

  • Microsoft Access 2002
This article was previously published under Q295212
Novice: Requires knowledge of the user interface on single-user computers.

This article applies only to a Microsoft Access project (.adp).

SYMPTOMS

After you change the data type of any field in a table that has a saved PivotTable view, the saved PivotTable view is lost and must be re-created.

STATUS

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

MORE INFORMATION

NOTE: The following steps require that Microsoft SQL Server 2000 Desktop Engine or Microsoft SQL Server 2000 or later is installed.

Steps to Reproduce the Behavior

  1. On the Help menu, point to Sample Databases, and then click Northwind Sample Access Project.
  2. In the Database window, click Tables under Objects, and then click the Order Details table.
  3. On the Edit menu, click Copy, and then click Paste.
  4. Name the table tblTestPivot, and then click OK.
  5. Open tblTestPivot table in PivotTable view.
  6. Drag the OrderID field from the PivotTable Field List box to the Drop Row Fields Here area.
  7. Drag the ProductID field to the Drop Column Fields Here area.
  8. Drag the UnitPrice field to the Drop Totals or Detail Fields Here area.
  9. Close the tblTestPivot table, and then click Yes when you are prompted to save the changes.
  10. Open the tblTestPivot table in Design View.
  11. Remove the primary key.
  12. Change the data type of the ProductID field to float.
  13. On the View menu, click PivotTable View. Click Yes when you are prompted to save the table.

    Note that PivotTable View is reset.

REFERENCES

For information about how to install the Microsoft SQL Server 2000 Desktop Engine, see the following article in the Microsoft Knowledge Base:

290627 ACC2002: SQL 2000 Desktop Engine Is Not Installed by Office XP

Modification Type:MajorLast Reviewed:9/26/2003
Keywords:kbbug kbnofix KB295212
©2003 Microsoft Corporation. All rights reserved.