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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dsum and Dmax with structured references 1
TransferDatabase problem 3
MS Access Table missing 4
copy table structure and queries to new database VBA 1
Copy table structure in Access 2000 4
enumerating tables collection or fields in ADOX blows up Access 4
Automatically generate a "create table" statement 5
Referential integrity constraints don't delete? 0

Top