Is there a simple way to duplicate / copy an en entire table? I am using VC++ / ADO ( Access database) and I need to duplicate tables during the program run. It is my understanding that ALTER will rename but not build a new table. Thanks for your time and help Vaclav
