Archive old records w/o loosing the ability to work w/ it.

M

Monica77

What is the best way to archive old records but still be able to work w/ all
my queries and forms if I ever had the need to do so?

I tried making a new table with old records and deleting the old records
from my original table; however, if I do that I will not be able to use my
forms and queries with the old table.
 
R

Rick B

Nooooooo.

Don't move them to a new table. Why? Simply filter out the old ones if
there is a date in the record. If there is not a date, then use an
'inactive' field to mark them as old.

Moving them to a different table only makes it more difficult and confusing
to use your data. Tell the database which records you want to use; if you
don't want old ones for a particular report or form, then don't pull them
there.

Just my opinion.

Rick B
 
Top