Archiving data

[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

 

[Jeff Boyce]

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!

 

[Allie]

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

 

[Allen Browne]

See:
Archive: Move records to another table
at:
http://allenbrowne.com/ser-37.html

The article explains how to archive safely into an external database, using
a copy and delete inside a transaction.

 

[Franckie Diago]

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

Thanks

HOW DO I FOUND ANSWER TO FAQ, LIKE THE ONE ABOVE ?
THANKS

 

[Adrian Jansen]

Use the newsgroup itself for a search, using Google, for example

http://groups.google.com/groups?hl=...ta=group=microsoft.public.access.tablesdesign

will allow you to search through all the articles for the last 10 years or
so. A *huge* resource. Always worth doing before posting a question.



--
Regards,

Adrian Jansen
J & K MicroSystems
Microcomputer solutions for industrial control