Backup table

[Richard B. Wright]

Greetings:

I have a table that I would like to backup on a periodic basis. My current
train of thought is to create queries/macros/event procedures to accomplish
this.

current table ---> click on cmd btn to purge all records 90 days old. I
want to append these records to a perviousily created table. Any ideas how
to do this without appending records already in the archived table?

Thanks,

Rick W.

 

[Kelvin Lu]

If you are purging the records that are to be backuped up, you shouldn't
have a problem about duplicate data. An easy way to accomplish this would
be to write a standard append query with the criteria set to
Date() - 90. Then a delete query. Make your button then run the two
queries.

Kelvin

 

[Richard B. Wright]

Thanks Kevin, I did as you suggested -- "write a standard append query
with the criteria set to

Date() - 90. Then a delete query. Make your button then run the two
queries." -- but the append query keeps appending the same records.

Thanks for any suggestions!