I think you guys are right and I will try to compress the database. I still wanted to archive some records to a history table. Would it be possible to have an access form with 2 buttons - one to search Customer database and another to search history table? User would press button 1 first to search and if record is not found, they would click the history button.

I would like to design an archive system for my access database. I have a Customer table that is quite large and is becoming slow to search for a record. We use an Access form to search for records via a Customer ID. I can reduce the size of the table by archiving old records to another table called History. However, I still want access to the historical records from the Access form when the record cannot be found in the Customer table. We could...