Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

  1. Home
  2. ACC2000: The Chart and the PivotTable Wizards Are Not Available in an Access Project

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

View products that this article applies to.

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

↑ Back to the top

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.

↑ Back to the top

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.

↑ Back to the top

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.

↑ Back to the top

Keywords: KB264657, kbclientserver, kbhowto

↑ Back to the top

Article Info
Article ID : 264657
Revision : 2
Created on : 6/29/2004
Published on : 6/29/2004
Exists online : False
Views : 268