ACC2002: When You Change the XML Location from Embedded to Data File, the Embedded XML Remains Part of the Data Access Page (281895)


The information in this article applies to:

  • Microsoft Access 2002
This article was previously published under Q281895
Moderate: Requires basic macro, coding, and interoperability skills.

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

SYMPTOMS

By using the new properties of the data source control, you can bind a data access page to XML data that is embedded within the data access page or in a separate XML file. Embedded XML is also known as a data island. If you bind the page to an XML data island and subsequently bind the page to a separate file, the data island remains part of the page.

CAUSE

This behavior is by design. This functionality enables you to switch between two separate XML data sources very quickly.

MORE INFORMATION

Steps to Reproduce the Behavior

  1. Open the Northwind Sample database, and then create a new data access page in Design View.
  2. In the field list, expand the Customers table.
  3. Add the CustomerID, CompanyName, and ContactName fields from the Customers table to the page.
  4. Right-click the Header: Customers section, and then click Page Properties.
  5. Click the Data tab, and then change the UseXMLData property to True.
  6. Save the data access page.
  7. Press CTRL+G to open the Immediate Window.
  8. Type the following code in the Immediate Window, and then press ENTER: 
    DataAccessPages(0).MSODSC.ExportXML
    This code creates XML embedded within the page and binds the page to this XML. You can view the embedded XML in the browser by clicking Source on the View menu in Microsoft Internet Explorer.
  9. Return to the data access page in Design View.
  10. Change the XMLLocation property to dscXMLDataFile.
  11. Change the XMLDataTarget property to C:\[PageName]_Data.xml where PageName is the name of your data access page.
  12. Repeat steps 7 and 8. This binds the page to the XML file that you specified in step 11. Note that if you view the source for the page, the embedded XML is still present.
Modification Type:MinorLast Reviewed:9/27/2006
Keywords:kbDAP kbprb KB281895
©2004 Microsoft Corporation. All rights reserved.