T Tom Jun 11, 2004 #1 What is the maximum number of records an Access 2000 database table can manage?
K Ken Snell Jun 11, 2004 #2 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.
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.
A Albert D. Kallal Jun 11, 2004 #3 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.
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.
