Access 2003 rows limits

S

Steven

What is the rows limits of ACCESS 2003 (1,000,000?) For DATABASE OF 2.1
Millions records can ACCESS 2003 deal with this?
 
D

Douglas J. Steele

There is no row limit per se. The only limit that exists is that an MDB file
cannot exceed 2 Gb in size.

Depending on your row size, Access should be able to handle 2.1 million
records.
 

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

Hitting the limits with large table in Excel containing 1 millionrecords. What is the best option fo 2
Exporting large tables 0
Any alternatives to excel? 4
AutoNumber Field Limits - NOT "How do I reset?" 11
Hitting the limits with Excel and need about 1 million rows of data.What is the best option for what 1
What are the Access 2007 record table limits? 2
How do I clear a form? 0
Old question regarding Access Templates. Any up to date answers, please 2

Top