Application.ExportXML gives wrong schema namespace

J

Jay

I am using Access 2002 exportXML to post xml over http to a .net aspx web
page. When the aspx page consumes the xml it gives error complaining to use
a different www.w3.org namespace.
The namespace that my export creates is:
http://www.w3.org/2000/10/XMLSchema-instance
The namespace that aspx wants is:
http://www.w3.org/2001/XMLSchema-instance

Here is the aspx error:
ERROR setXmlSchema: System.ArgumentException: The schema namespace is
invalid. Please use this one instead: http://www.w3.org/2001/XMLSchema.
at System.Data.DataSet.ReadXmlSchema(XmlReader reader, Boolean
denyResolving)

Here is my exportXML code:

Application.ExportXML ObjectType:=acExportTable, DataSource:="WS_q",
DataTarget:=strFile, SchemaTarget:=schemaFile 'access2002

Here is the top 3 lines of my xml file:

<?xml version="1.0" encoding="UTF-8"?>
<dataroot xmlns:eek:d="urn:schemas-microsoft-com:eek:fficedata"
xmlns:xsi="http://www.w3.org/2000/10/XMLSchema-instance"
xsi:noNamespaceSchemaLocation="WS_q.xsd">
<WS_q>

Any ideas on how to get Access2002 to exportXML for the appropriate namespce?
Thanks
 
Top