Max rows in Access

  • Thread starter Thread starter Anthony Acri
  • Start date Start date
From the main Access window, open help and choose Specifications.

There is not a set number of rows, but an mdb file cannot exceed 2
gigabytes.

In practice, if you foresee millions of records in any one table, you might
be better planning on a larger database.
 
Theoretically for JET databases, there is no limit on the
number of rows per Table, only size limit for the database
file: 1 GB for A97, 2 GB for A2K & later versions.

Check "Specification" in Access Help for other limits.

HTH
Van T. Dinh
MVP (Access)
 
Back
Top