Microsoft Knowledge Base Email Alertz

(828411) - Describes a problem that occurs when you have an Office Chart 11.0 control in a data access page. You may not be able to use Microsoft Office Data Source Control (MSODSC) to connect to a data source. Includes 3 resolution methods. Requires basic skills

Search KbAlertz

Advanced Search

Receive Microsoft Knowledge Base articles by E-Mail?

Every night we scan the Microsoft Knowledge Base. If technologies you're interested in are updated, we'll send you an e-mail. You only get one e-mail a day, and only when new articles are added.

Click here to create a
FREE account
Already have an account?
[Click here to Login]











Microsoft Knowledge Base Article

This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved. Terms of Use | Trademarks

Article ID: 828411 - Last Review: September 27, 2006 - Revision: 1.5

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

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.

APPLIES TO
  • Microsoft Office Access 2003
Keywords: 
kbprogramming kbdap kbofficewebchart kbdragdrop kbcontrol kbprb KB828411
       

Community Feedback System

Very often, it takes hours to solve a problem. Very often, you've looked high and low, and have tried a lot of solutions. When you finally found it, chances are, it was because someone else helped you. Here's your chance to give back. Use our community feedback tool to let others know what worked for you and what didn't.

Please also understand that the community feedback system is not warranted to be correct, it's simply a system that we've built to let people try and help each other. If something in a feedback response doesn't make sense to you, or you're not comfortable making changes that the feedback talks about (like registry edits), please consult a professional.

Thank you for using kbAlertz.com Feedback System.

-- Scott Cate