codedb.Containers("tables").Documents

  • Thread starter Thread starter david epsom dot com dot au
  • Start date Start date
D

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)
 
Why use the document object at all? Use TableDefs and QueryDefs...TableDefs
and QueryDefs have a Name property.
 
Back
Top