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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top