Make Copy of file in one table & copy it to another table

[Guest]

I have a table with records in it and these records need to be in its
original state.
But I need to make updates to these records and put these records into
another table. How could I do this?
Thanks Terry

 

[fredg]

I have a table with records in it and these records need to be in its
original state.
But I need to make updates to these records and put these records into
another table. How could I do this?
Thanks Terry

Manually?
Select the table on the main database folder, right-click Copy, then
right-click on a blank part of the main folder and Paste.

Using VBA?
DoCmd.CopyObject , "NewTableName", acTable, "TableName"

You could also use a Make Table query.

 

[John Vinson]

I have a table with records in it and these records need to be in its
original state.
But I need to make updates to these records and put these records into
another table. How could I do this?
Thanks Terry

Well, if the records need to be preserved in the first table in their
original state, then reverse the order of operations. Run an Append
query to put them into the second table, and then modify them there.

You don't say anything about the structure of the tables or the nature
of the modification so it's a bit hard to be specific!

John W. Vinson[MVP]

 

[Guest]

Sorry Guys I didn't make myself clear - I have a table ContractsOriginal
which needs to be kept perement. If a contract is changed I want another
table called ContractUpdate to hold records that are changed - is there a way
to copy the ContractsOriginal record into the ContractUpdate table without
rekeying the data into the ContractsUpdate table.

 

[John Vinson]

Sorry Guys I didn't make myself clear - I have a table ContractsOriginal
which needs to be kept perement. If a contract is changed I want another
table called ContractUpdate to hold records that are changed - is there a way
to copy the ContractsOriginal record into the ContractUpdate table without
rekeying the data into the ContractsUpdate table.

Yes. And I told you how: read again.

====================================== LOOK HERE =====================

======================================================================

John W. Vinson[MVP]

 

[Guest]

Thanks for the help John - I will do some research on an append query - Terry