Record Numbers

  • Thread starter Thread starter Darryn Ross
  • Start date Start date
D

Darryn Ross

Hi..

Is there or what is the limit for the number of records a table can hold in access '97?

thankz
 
Hi..

Is there or what is the limit for the number of records a table can
hold in access '97?

thankz
Click to expand...

There is no limit real on the total number of records an Access 97
table can hold. There is a total size limit for the entire database
(forms, reports, tables, data, etc.) of 1 Gb.

In Access 2000 and newer it is 2 Gb.
 
Hi..

Is there or what is the limit for the number of records a table can hold in access '97?

thankz
Click to expand...

There is no explicit limit. See SPECIFICATIONS in the online help.
You're limited to 1 GByte (a billion bytes, enough for several
encyclopedias) in any single .mdb file.

In practice, if you're storing more than five or ten million records
in the largest table you should start seriously looking at
client-server applications.
 
Back
Top