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