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

[Guest]

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.

 

[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

 

[Joseph Meehan]

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.

Add an "active"(*) field. A simple binary (check box) filed then set
your usual queries to filter out those marked "inactive." Another set of
queries (or changing the one(s) you have will allow you to work with the
archived-old records or all the records.

(*) You can also call it inactive or archived if you like.