validate XML within Access (2000, 2002, 2003, and 2007)

[rick allison]

This may not be the right newsgroup. Please direct me to the best one if
necessary.

My VBA creates XML, the hard way one character at a time, so to speak.

Once the XML is done I'd like to validate it against a Schema.

Is it possible to validate XML using a MS Access tool? Is there such a
tool?

I want to be able to validate the XML and if there are issues show them in
MS Access so the user can fix them and then try again.

Thanks,

Rick

 

[Stefan Hoffmann]

hi Rick,

My VBA creates XML, the hard way one character at a time, so to speak.

There are only two ways:

1. http://msdn.microsoft.com/en-us/library/aa221224(office.11).aspx
2. using MSXML

Once the XML is done I'd like to validate it against a Schema.

I would use

http://msdn.microsoft.com/en-us/library/ms757071(VS.85).aspx

btw, use MSXML v6.


mfG
--> stefan <--

 

[rick allison]

Thanks Stefan.

Having read the information from the links you provided is MSXML native to a
Windows computer? In other words, does it come built in or do I need to
download it and install it?

My application is used by individuals all over the place. If they have to
download MSXML that's not a good option for me.

I need a way to validate XML with tools that everyone already has, if that
is possible.

Thanks,

Rick

 

[Tom van Stiphout]

On Fri, 10 Apr 2009 15:26:13 -0400, "rick allison"

No, Access has no specific tools to validate XML.

-Tom.
Microsoft Access MVP

 

[Stefan Hoffmann]

hi Rick,

Having read the information from the links you provided is MSXML native to a
Windows computer? In other words, does it come built in or do I need to
download it and install it?

This dependes as always on the Windows version. MSXML should be on every
system as least as version 3. The newer ones are installed with
different kind of (MS) applications.

http://en.wikipedia.org/wiki/MSXML

My application is used by individuals all over the place. If they have to
download MSXML that's not a good option for me.

Users have to keep there computers up-to-date. So I don't think that
this is a problem at all. At least you can provide a setup.

I need a way to validate XML with tools that everyone already has, if that
is possible.

MSXML


mfG
--> stefan <--