Microsoft KB Archive/307422

= Exporting as XML from Access 2002 produces WC3 2000-compatible schema =

Article ID: 307422

Article Last Modified on 3/7/2006

-

APPLIES TO


 * Microsoft Access 2002 Standard Edition
 * Microsoft Visual Studio .NET 2002 Professional Edition

-



This article was previously published under Q307422



SYMPTOMS
If you open a schema that is produced by using Access, you receive the following error message in the Visual Studio .NET designer:

The XML Designer encountered the following error while reading this file:

Document Element tag xsd:schema must identify the XSD schema namespace. Do this by adding an attribute xmlns=&quot;http://www.w3.org/2001/XMLSchema&quot; to the Document Element tag

Please return to source view and correct these errors.



CAUSE
The Access schema identifies an earlier draft of the XSD namespace as follows:

http://www.w3.org/2000/10/XMLSchema

However, Visual Studio .NET supports the most recent draft, which is as follows:

http://www.w3.org/2001/XMLSchema



RESOLUTION
To work around this issue, replace the following line:



with the following line instead:





STATUS
This behavior is by design.



MORE INFORMATION

 * 1) In Access 2002, select a table that you want to export.
 * 2) Right-click the table, and then click Export on the shortcut menu.
 * 3) In the Save as Type list, select XML Documents.
 * 4) In the dialog box that appears, select Schema of Data.
 * 5) After you save this file where you want it, right-click the file, and then click Visual Studio .NET to open the file.

You receive the error message indicated in the &quot;Symptoms&quot; section.

