Max rows in Access

A

Allen Browne

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.
 
V

Van T. Dinh

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)
 

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

Resource Leveling Multiple Resources on one task 0
Max Length in a row 1
Repeating a row other than the 1st row as the header row in a table from next page 1
Quick/efficient way to VBA subtotal 2
can max() be used within IIf() function in MS Access 1
Changing row background from external program 0
Max only if the last month is hte highest 4
SQL help..HAVING MAX(??) 1

Top