Archiving data

  • Thread starter Thread starter Allie
  • Start date Start date
A

Allie

I would like to archive data on the 15th of every month.
How do I create a macro or procedure to do this?

Thanks
 
Allie

Define "archive"...

Some folks figure that means removing rows from one table and sticking them
in another. This creates headaches if you ever have to recombine.

Another approach is to use either a Yes/No field (Archived?) or a Date/Time
field, into which you store the date "archived".

If you use the latter approach, you can modify your queries, forms and
reports to only use the un-archived rows, and, to the user, it will appear
that they are only using "live" data.

If performance is a concern, index the field.

And when the day comes that you have to "look up" historical information,
it's all in there!
 
I would need to move the data to a new table in another
(archived) database. The data would be put on CD every few
months.

I would not need to retrieve the data since the "live"
database will always contain a summary of the data that
was archived.

Thanks
 
I would like to archive data on the 15th of every month.
How do I create a macro or procedure to do this?

Thanks
Click to expand...
HOW DO I FOUND ANSWER TO FAQ, LIKE THE ONE ABOVE ?
THANKS
 
Back
Top