ACC2000: The Chart and the PivotTable Wizards Are Not Available in an Access Project (264657)


The information in this article applies to:

  • Microsoft Access 2000
This article was previously published under Q264657
Moderate: Requires basic macro, coding, and interoperability skills.

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

SUMMARY

The Chart Wizard and the PivotTable Wizard are not available in a Microsoft Access project (.adp). However, you can use these wizards in a Microsoft Access database (.mdb) file, and then import the results (the form or the report for the Chart Wizard or the form for a PivotTable Wizard) into a Microsoft Access project. This article shows you how to do so.

The example in this article assumes a scenario in which you want to have a PivotTable within the sample project NorthwindCS.adp.

MORE INFORMATION

The following example shows you how to use the PivotTable Wizard in an Access database (.mdb), and then how to import the results into an Access project (.adp):
  1. Create a User or System DSN that points to the Northwind database on SQL Server or MSDE. Assign NwindCS as the new DSN name.
  2. Create a blank, new Access database named Db1.mdb.
  3. On the File menu, point to Get External Data, and then click Link Tables.
  4. In the Files of type list, click ODBC Databases.
  5. In the Select Data Source dialog box, click the Machine Data Source tab, click NwindCS, and then click OK.
  6. In the SQL Server Login dialog box, click Options and make sure that the Database box points to Northwind. Then, click OK.
  7. Select only the table(s) necessary to create the PivotTable, and then click OK.
  8. In the Database window, click Forms under Objects, and then click New.
  9. Select the PivotTable wizard, and then step through the wizard until you have successfully created the PivotTable form.
  10. Save the form, and then open NorthwindCS.adp.
  11. On the File menu, point to Get External Data, and then click Import.
  12. Import the PivotTable form from Db1.mdb into NorthwindCS. Because both Db1.mdb and NorthwindCS use the same tables, the imported form will properly function within NorthwindCS.

REFERENCES

For more information about the Chart or PivotTable Wizards, click Microsoft Access Help on the Help menu, type Chart Wizard or PivotTable Wizard in the Office Assistant or the Answer Wizard, and then click Search to view the topics returned.
Modification Type:MajorLast Reviewed:6/29/2004
Keywords:KbClientServer kbhowto KB264657
©2004 Microsoft Corporation. All rights reserved.