Access Table Record Limitation

N

NKK

Can anyone tell me how me records Access 2003 can handle
in one table. I realize the overall Size of the database
can be 2 GIGS. However, I think FoxPro claims it can
handle 1 billion records. If anyone knows this
information it would be great. I have already looked at
the spec site and it does not say.
 
C

Cheryl Fischer

There is no limitation as to the number of records a single table may hold,
as long as the total size of the database does not exceed 2 GB. There *are*
other specifications regarding tables and you can review them by opening
Access Help and typing the word: specifications in the Answer Wizard.
 

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

Trying to create a report that will list unmatched records by Ticket Primary Key 0
Copy previous record into form field 0
Crash on Close from 2 stable Access forms after unsolicited install of VS 2015 0
How do I clear a form? 0
Old question regarding Access Templates. Any up to date answers, please 2
Hitting the limits with large table in Excel containing 1 millionrecords. What is the best option fo 2
Hitting the limits with Excel and need about 1 million rows of data.What is the best option for what 1
DMax on existing record to increment serialized # fails 1

Top