Microsoft KB Archive/295212

= ACC2002: Changing the Data Type of Any Field in a Table Resets the PivotTable View =

Article ID: 295212

Article Last Modified on 9/26/2003

-

APPLIES TO


 * Microsoft Access 2002 Standard Edition

-



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.

