create table from table

[Bill H.]

What is the VBA code for creating an empty table from an existing empty
table?

Thx.

 

[fredg]

What is the VBA code for creating an empty table from an existing empty
table?

Thx.

DoCmd.CopyObject , "NewTableName", acTable, "OldTableName"

 

[Bill H.]

Thank you!

but how to automatically delete the newtablename if it already exists
without getting the access prompt?