Archiving Data ?

[Guest]

How do i archive data ?

Ideal thing would be that the users could delete/modify/add data and when
they would feel the need, they could archive the data just by using some
macro or something similar.

 

[Tom]

You can take a backup copy of the mdb file at regular intervals.
But if you want to archive individual records from various tables it is up
to your design of the database.

 

[Joseph Meehan]

How do i archive data ?

Ideal thing would be that the users could delete/modify/add data and
when they would feel the need, they could archive the data just by
using some macro or something similar.

Define Archive. Do you mean store inactive data that you want to hide
from the usual day to day activity, but still have access to from time to
time? Or do you mean you want to back up your data to protect it from
loss?

Assuming the first and also assuming it is not an extremely large amount
of data, I suggest adding an additional binary filed to the table(s) and
indicate yes for archived and no for current. (other way around if you
like). From then on you can use filters or queries to display just current
data, just archival data or all data.