Maximum number of records

  • Thread starter Thread starter Tom
  • Start date Start date
There is no maximum number of records. The "maximum" is dictated by the fact
that an ACCESS 2000 file cannot exceed 2 GB in size.
 
The size limit of access 2002 is 2 gigs.

So, if you take a average name in a mailing list, add a few extra
fields...your record size might be about 120 characters on average in size.

So, the number of records you can store is:

2 gig / 120 = 32 million records

So, the limit is NOT the number of records..but "how many" records you can
fit into 2 gig.

Of course, if each customer name only takes up 60 characters...then you can
store 64 million records in the file.
 
Back
Top