A fast and Easy way to populate records from Temp Table to Permanent Table?

[Aldred@office]

Hi all,
I am trying to solve a problem for the company which I chosed to use Temp
table. In some certain conditions, we need to populates all the records
from the temp table to the Permanent table for storage and further process.
Is there a way which I could easily populate the records from Temp to Perm?
Two tables are basically identical, except both of them has a unique
Automatically generated ID field.

Thanks.

 

[Allen Browne]

You can execute an Append query to add the new records in the Temp table to
the Permanent table, but there are many factors that are likely to turn the
process into anything but "a fast and easy way" to handle your data.

Examples:
a) Are they all new records? Or might some be edits of existing records?

b) Could other users be entering/editing/deleting records in the permanent
table (or in your temp table), and if so, how will you handle clashes?

c) The automatically generated ID probably won't work. Whatever number is
assigned in your temp table could potentially clash with a record in the
permanent table.

You might consider replication, but be aware that it has been removed from
the new format in A2007 so that might be a dead-end street.