Max # of records in Access 2002?

  • Thread starter Thread starter Dwayne
  • Start date Start date
D

Dwayne

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.
 
Dwayne said:
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.
Click to expand...

There is no "record limit". The limit is that no single table or file can
exceed 2 GB.
 
Back
Top