Обсуждение: 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.

On Thu, 5 Oct 2000, Amy Antle wrote:

> 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???

Is this a question for MS-Access or for PostgreSQL?

Brett W. McCoy
                                              http://www.chapelperilous.net
---------------------------------------------------------------------------
The Kennedy Constant:
    Don't get mad -- get even.