ACCESS 2002

[RSANCHEZ]

I HAVE SEVERAL MONTHS OF INFO SLOWING DOWN MY PROGRAM. HOW
DO I PULL OLD INFO AND STORE IT? i MUST BE ABLE TO GET IN
TO IT FROM TIME TO TIME.

 

[Ken Snell]

First, explore whether your queries are unnecessarily including "old"
information when they return records. Change them to only pull the data you
really want.

Otherwise, create new table(s) for archiving "old" data. Use an append query
to copy the "old" data into the new table(s), and then use a delete query to
delete those "old" data from the original table(s).