Making a copy of an existing table?
So you just have to get all the attributes of the original and build the new
table then do the data movement.
Seems like a hassle but it's really not, esp if you use DAO since the Object
model is simple comapred to aADO's non-model. Write it as a generic class
or module and use it to automate the process at any time with any table.
For source code that might get you started on running thru the current
table's details (and creating a "definition" for the copy table):
http://www.smithvoice.com/jet.htm
Hope it helps
-Robert Smith
Kirkland WA
Quote:
>This alone will not "copy a table". It is simply taking the data portion
>alone and setting it into a new table without any special attributes the
>prior table included such as indexes. You have to rebuild these yourself
>afterwards.
>Al Meadows
