There is no limit on the number of records that an Access database can
contain, as long as the total size of the MDB file does not exceed 1GB (for
Access 97 and older versions) or 2GB (for Access 2000 and newer versions).
You can view this and all other specifications for your version of Access by
clicking Help and typing the word: specifications in the Answer
Wizard.