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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

About Access limits 15
Maximum record size and maximum number of records 3
Number of records 3
Maximum Revisions? 8
Access 2007 1
maximum # of records of Access 2000 and 2002 0
Whats the maximum number of rows Access 2007 can take? 3
Recordsource for subforms 2

Back
Top