ms-access does not actually have a record limit. However, ms-access does
have a file size limit.
Hence, the max number of records will vary, since you can put more smaller
records in a file then large size records.
The max file size of a database is 2 gigs. Further, data in ms-access is
stored as uni-code, and thus each characters actually takes up two bytes. In
addition, ms-access does use some compression on text fields.
lets do a quick calc, and assume a max size of 1 gig for our use...
A mailing list with just a name + address is about 85 characters on average.
So,
1,000,000,000 / 85 = 11 million records.
On the other hand, if each record was 160 characters..then you are talking
only 5 million records..
ms-access is really zippy with small files...say only 75,000 to 150,000
records....
