Record Numbers

[Darryn Ross]

Hi..

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

thankz

 

[fredg]

Hi..

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

thankz

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.

 

[John Vinson]

Hi..

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

thankz

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.