codedb.Containers("tables").Documents

[david epsom dot com dot au]

I am iterating through the Documents collection of the Tables Container to
get a list of objects to update from a reference database:

sName = codedb.Containers("tables").Documents(23).Properties(13).Name

This container contains both TableDefs and QueryDefs.

I need to separate the TableDefs and Querydefs so that I can use
TransferDatabase to import the objects:

DoCmd.TransferDatabase acImport, "Microsoft Access", _
"C:\capix\dp8.mdb", rs!nType, rs!sName, rs!sName


Is there any clean way to do this? Or do I have to use a different approach?

(david)

 

[Paul Overway]

Why use the document object at all? Use TableDefs and QueryDefs...TableDefs
and QueryDefs have a Name property.