Reproduce table structure? 1

[WaltW]

In one click event on one of my forms, I need to be able to create a new table, then exactly duplicate the structure (not the data) of an already-existing table in the new table. What's the simplest and quickest way to do this in VBA? The only thing I've been able to come up with so far is to reproduce each field one at a time - is there a way to reproduce the entire structure at once?

WaltW

 

[MichaelRed]

You can copy the entire table (CopyObject Method) and do a delete * query on the new database. There are other vialble approaches. However, this works well for tables which do not have a lot of records. (If there are a LOT of records, the copy and delete processes take to much time).



MichaelRed
mred@duvallgroup.com
There is never time to do it right but there is always time to do it over

 

[overClok6]

I'm about to do this very thing in a project. Use the TransferDatabase method of the DoCmd object, setting the structureonly parameter to True. That will copy the entire structure of your source table into a new table you specify, even in a different database if you wish.