My PivotTable and Chart controls don't work in Access 2007

Symptoms

When you open a Microsoft Office Access 2003 or earlier Microsoft Access file format database in Access 2007, one of the following messages appears:

• Your Microsoft Office Access database or project contains a missing or broken reference to the file '0WC10.DLL' version 1.0.

• Your Microsoft Office Access database or project contains a missing or broken reference to the file '0WC11.DLL' version 1.0.

Access 2007 opens the database file, but any Microsoft Office PivotTable controls or Microsoft Office Chart controls that are contained on forms, reports, or data access pages do not work. In addition, Access might show the message "There is no object in this control" when you open an object that contains a PivotTable control or Chart control.

Cause

The database contains one or more controls that were created by using Microsoft Office 2003 Web Components or earlier. By default, Access 2007 does not install these versions of Microsoft Office Web Components. Therefore, the reference to the files is broken and the controls no longer work.

Note: The issue described in this article applies to PivotTable or Chart controls that you can add to a form, report, or data access page. By contrast, PivotTable and PivotChart views of objects that were created in Access 2003 and earlier versions of Access continue to work in Access 2007. These views are available by clicking View on the Home tab, and then clicking PivotTable View or PivotChart View.

When you add controls such as the Microsoft Office PivotTable control to a form, report, or data access page, Access creates references to dynamic-link libraries (DLLs) that support those controls. Later versions of Access might not include all the .dll files that you need for controls that you added while you were working on your database in earlier versions of Access. In this case, you must download and install these .dll files separately to continue using the controls that depend on them. By default, Access 2007 does not install either of the version 10.0 or version 11.0 Microsoft Office Web Components.

The following list shows a sample of some controls that are affected by this issue:

• Microsoft Office Chart 10.0

• Microsoft Office Chart 11.0

• Microsoft Office PivotTable 10.0

• Microsoft Office PivotTable 11.0

Resolution

To make Access 2007 display your earlier version PivotTable controls and PivotChart controls correctly, you must download and install the correct .dll file or files. Use the following procedures to determine which files you need, and then download and install those files.

Determine which reference is missing

1. Open the database in Access 2007.

2. Do one of the following to open the Visual Basic Editor:

   • Open an existing module by double-clicking it in the Navigation Pane.

   • On the Create tab, in the Other group, click Module. If this command is unavailable, click the arrow beneath either the Macro or the Class Module button, and then click Module.

3. In the Visual Basic Editor, on the Tools menu, click References.

4. In the References dialog box, under Available References, look for any references that are marked MISSING.

   • If either version 10.0 or version 11.0 of the Microsoft Office Web Components is missing, use the following procedure to download and install the required .dll file.

Download and install the required file

1. Search the Microsoft Download Center for owc10.exe or owc11.exe, depending on which version you determined was missing in the previous procedure.

2. Follow the instructions in the Download Center to download and install the file. Note that you can either save the .exe file to your computer and then run it to install the .dll file, or you can click Run to install the .dll file directly from the Download Center.

3. After the installation is finished, close and then reopen your Access database application to confirm that the controls work as expected.