[AccessD] ExportXML fails calulated where in acc2003?

Hi,

And the answer is... ADO ANSI 92 wildcards vs MDB VBA wildcards. 

It turns out that ExportXML uses ADO, which uses ANSI 92 wildcards. My
query uses wildcards that conform to VBA as explained in the Microsoft
Access 2003 help topic: About ANSI SQL query mode (MDB).

I had searched the MS knowledge base for "ExportXML" before posting this
issue to AccessD. I didn't find anything relevant. 

If I would have searched the knowledge base with "Export XML", I would
have found the following article.

823224  Access queries with a wildcard character do not export data to
an XML document

I've learned many things from this experience. I think I will be setting
the "This database" checkbox in the "SQL Server Compatible Syntax (ANSI
92)" section of the "Tables/Queries" tab of the "Tools, Options..."
dialog in Access for any new database work I do. That way the queries I
write will be compatible across ADO, SQL server and the MDB.

Has anyone else been turning on ANSI 92 compatibility for new work done
in 2002-2003 file format MDBs?

I think it will bring me one step closer to SQL Server, which is a good
thing... I think.?

Thanks,
 
Eric