Max # of records in Access 2002?

message from Dwayne on 18 May 2004
All,
Does anyone know what the maximum number of records that
are allowable in the Access 2002 environment? I have
often created sample sizes that have exceeded Excel
capabilities and was wondering if Access had the same
limitations in the number of records or rows of data.
 
Rick Brandt replied to Dwayne on 18 May 2004
There is no "record limit". The limit is that no single table or file can
exceed 2 GB.
 

Archived message: Max # of records in Access 2002? (MS Access Error Message)