Record limit in access

  • Thread starter Thread starter Mark
  • Start date Start date
M

Mark

Hi,
What is maximum record limit in access database (in one table and all
tables)?
I have database which will have over 500.000 records in one table. Is this
too much for access?
I am beginner :)

Thanks in advance
 
There is no maximum number of rows. The only maximums Access has is the
total size of the MDB file cannot exceed 2 Gb (1 Gb in Access 97 and
earlier), and the size of a single record cannot exceed 2000 characters.

I've worked with tables having in excess of a million rows.
 
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

Record-Locking remains open after closing 0
About Access limits 15
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Hitting the limits with large table in Excel containing 1 millionrecords. What is the best option fo 2
AutoNumber Field Limits - NOT "How do I reset?" 11
Access 2003 vs 2010 1
insert a deleted record back in access table at the same location 2
Access limitations? 6

Back
Top