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


The information in this article applies to:

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

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

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

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.

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

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.
Modification Type:MinorLast Reviewed:9/27/2006
Keywords:kbProgramming kbDAP kbOfficeWebChart kbDragDrop kbControl kbprb KB828411 kbAudDeveloper
©2004 Microsoft Corporation. All rights reserved.