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)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

TPM 1.2 2
can max() be used within IIf() function in MS Access 1
Max Function in Row Source Coding 2
Max Length in a row 1
What is the max number of rows in a table? 5
DoCmd.OutputTo error 2606 too many rows 1
Select & Max Function Q 3
News Apple unveils iPhone XS, iPhone XS Max and iPhone XR 0

Back
Top