ACCESS 2002

  • Thread starter Thread starter RSANCHEZ
  • Start date Start date
R

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.
 
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).
 
Back
Top