Microsoft KB Archive/828408

= Cannot connect to the component data source if the Web page contains Office 2003 Web components =

Article ID: 828408

Article Last Modified on 7/28/2006

-

APPLIES TO


 * Microsoft Office Access 2003

-



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

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



SYMPTOMS
If you try to edit an existing Web page in Microsoft Office Access 2003 and the Web page has Microsoft Office 2003 Web Components, such as a PivotTable, the Web page cannot connect to the component data source. You may receive the following error message:

The query could not be processed:

0 Safety settings on this machine prohibit accessing a data source on another domain



CAUSE
This problem occurs because Access 2003 does not support Office 2003 Web Components.



STATUS
This behavior is by design.



MORE INFORMATION
Office 2003 Web Components is a collection of COM controls that can be used in Web pages. These controls permit you to publish interactive data as part of a Web page. In Access 2003, you can create a data access page and view the page on the Web. However, Access 2003 does not support Office 2003 Web Components. Access 2003 uses Microsoft Office XP Web Components. Office XP Web Components are installed as part of Microsoft Office 2003.

Although Access 2003 does not support Office 2003 Web Components, other Office 2003 products, such as Microsoft Office Excel 2003 and Microsoft Office FrontPage 2003, support Office 2003 Web Components. Therefore, you can create a Web page that contains Office 2003 Web Components by using the Office 2003 products that support Office 2003 Web Components. If you try to edit one of these Web pages by using Access 2003, you may receive the error message that is mentioned in the &quot;Symptoms&quot; section of this article.

Note In Access 2003, you can add Office 2003 Web components to data access pages by using the Insert ActiveX Control command. However, you cannot use the components that you add to data access pages.

