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.

You cannot use the MSODSC control when you insert an Office Chart 11.0 control in a data access page


View products that this article applies to.

This article applies to a Microsoft Access database (.mdb) and to a Microsoft Access project (.adp).

Moderate: Requires basic macro, coding, and interoperability skills.

↑ Back to the top


Symptoms

When you insert a Microsoft Office Chart 11.0 control in a data access page by using the Insert ActiveX Control dialog box, you may not be able to use Microsoft Office Data Source Control (MSODSC) to connect to a data source.

Additionally, in the Office Chart control in the Commands and Options dialog box, you may notice that the Data from the following web page item option is unavailable (appears dimmed).

↑ Back to the top


Resolution

To resolve this problem, use the Microsoft Office Chart 10.0 control instead of the Office Chart 11.0 control in a data access page.

To insert an Office Chart 10.0 control in a data access page in Design view, use one of the following methods:
  • In the Toolbox, use the drag-and-drop feature to move the Office Chart control to the data access page.
  • On the Insert menu, click Office Chart.
  • In the data access page, insert the Office Chart control by using the Insert ActiveX Control dialog box. To do this, follow these steps:
    1. On the Insert menu, click ActiveX Control.
    2. In the Insert ActiveX Control dialog box, click Microsoft Office Chart 10.0 in the Select an ActiveX Control list.
    3. Click OK.

↑ Back to the top


More information

To view the version of the Office Chart control that is inserted in a data access page in Microsoft Office Access 2003, follow these steps:
  1. In the data access page, click the Office Chart control.
  2. Right-click the Office Chart control, and then click About.
  3. In the About Microsoft Office Web Components dialog box, view the version information.

Steps to Reproduce the Problem

  1. Start Access 2003.
  2. Create a new, blank database.
  3. In the Database window, click the Pages tab, and then click New.
  4. In the New Data Access Page dialog box, click Design View, and then click OK.
  5. On the Insert menu, click ActiveX Control.
  6. In the Insert ActiveX Control dialog box, click Microsoft Office Chart 11.0 in the Select an ActiveX Control list.
  7. Click OK.

    Notice that the Microsoft Office Web Components control is inserted in the data access page.
  8. Select the Microsoft Office Web Components control.
  9. Right-click the Microsoft Office Web Components control, and then click Data.

    Notice in the Commands and Options dialog box that the Data from the following web page item option is unavailable (appears dimmed).

↑ Back to the top


References

For more information about the Microsoft Office Chart control, click Microsoft Office Access Help on the Help menu, type Office Chart in the Search for box in the Assistance pane, and then click Start searching to view the topic.

↑ Back to the top


Keywords: KB828411, kbprb, kbcontrol, kbdragdrop, kbofficewebchart, kbdap, kbprogramming

↑ Back to the top

Article Info
Article ID : 828411
Revision : 6
Created on : 9/27/2006
Published on : 9/27/2006
Exists online : False
Views : 247