Question

Hi,
I have 2 tables in Access.  I want one of them to act as an archive table.
The first table collects records for a tempoary amount of time, and then
drops them into another table that will store them and keep growing and
growing each time it receives more and more records.
I have tried an insert but it just keeps overwriting itself.
Any suggestions???
Thanks
_________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.

Share information about yourself, create your own public profile at
http://profiles.msn.com.