using a macro

[rasha]

how to do macro that will copy Design from table to another table
just a design not include the data

then how to do macro that will Replace these two tables with each other

 

[Jeff Boyce]

You are asking a "how" question, but I'm curious about the "why". What will
having a copy of a table and then swapping the two allow you to do?

Regards

Jeff Boyce
Microsoft Office/Access MVP