Copying Table structure with TransferDatabase slow

A

aybs10

Using Access 2000 db in Access2003 Environment.

Hi - I'm trying to copy just the table structure from one database to
another database from a 3rd database. The main statement I'm using is:

objACC.DoCmd.TransferDatabase acImport, "Microsoft Access", strSource, ,
tdf.Name, tdf.Name, True

While it does work fine, it seems quite slow. I have about 120 tables and it
takes about a second a table. This is a little painful. Any other methods out
there or tips that I could use to speed this up?
 
Top