If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Maximum number of records
What is the maximum number of records an Access 2000
database table can manage? |
#2
|
|||
|
|||
Maximum number of records
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. -- Ken Snell MS ACCESS MVP "Tom" wrote in message ... What is the maximum number of records an Access 2000 database table can manage? |
#3
|
|||
|
|||
Maximum number of records
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. -- Albert D. Kallal (Access MVP) Edmonton, Alberta Canada http://www.attcanada.net/~kallal.msn |
Thread Tools | |
Display Modes | |
|
|