I want to archive with Access and also be able to search the archive and the current database when there is a query.

Any help to point me in the right direction is appreciated.