stanl
09-27-2007, 11:57 AM
I know I am doing something wrong, just cannot correct. Assume I have code that creates an Access.Application Object and I select an .mdb file cMDB
Now I want to create an XSD for a given table in the MDB. I appears that in order to execute the ExportXML() method [Access 2003], I need to use Application.OpenCurrentDatabase(cMDB); then to iterate the tables I need to
set ws = Application.DBEngine.CreateWorkspace("JetWorkspace", "admin", "")
Set db = ws.OpenDatabase(cMDB)
Assume the table chosen is named "MyTable"
Application.ExportXML(acExportTable, "MyTable", ,"c:\temp\MyTable.xsd", , , ,)
is required.
So it's like I'm opening the database twice. Is there a way to combine searching for Tabledefs and still executing ExportXML from the Application w/out opening the database twice????:banghead: Stan
Now I want to create an XSD for a given table in the MDB. I appears that in order to execute the ExportXML() method [Access 2003], I need to use Application.OpenCurrentDatabase(cMDB); then to iterate the tables I need to
set ws = Application.DBEngine.CreateWorkspace("JetWorkspace", "admin", "")
Set db = ws.OpenDatabase(cMDB)
Assume the table chosen is named "MyTable"
Application.ExportXML(acExportTable, "MyTable", ,"c:\temp\MyTable.xsd", , , ,)
is required.
So it's like I'm opening the database twice. Is there a way to combine searching for Tabledefs and still executing ExportXML from the Application w/out opening the database twice????:banghead: Stan