Backup table

  • Thread starter Thread starter Richard B. Wright
  • Start date Start date
R

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.
 
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
 
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.
Click to expand...
Thanks for any suggestions!
 
Back
Top