Max number of rows allowed in access table

M

Mike

Does anyone know the maximum number of rows that MS Access
will allow in a single table? Thanks
 
T

Tim Ferguson

Does anyone know the maximum number of rows that MS Access
will allow in a single table?
Click to expand...

Unlimited up to the storage capacity of a mdb file, which is 2 GB.

Hope that helps


Tim F
 

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

Repeating a row other than the 1st row as the header row in a table from next page 1
How to Submit rows of a repeating table to a SharePoint list 1
Delete all data after a symbol in a field 0
Dealing with a Pivot Table (when I don't want to) 0
Cannot bring rows to Height 1 in Print view 0
Insert Index into a Table 1
Adding Network Trusted Location on MS O365 Word per Computer Registry Setting 1
Autonumber field in Excel that behaves the same as Access 0

Top