Has anyone any idea of the limit on records in an Access 97 database. The data we have is approx. 1,000,000 records and we need to use this as an archive.