Database Size

[Guest]

How many records can an Access 2003 database have before it becomes to large
(e.g. an Ecxel file can have 65536 rows)?

 

[Albert D. Kallal]

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....

 

[Guest]

hi,
in access help type specifications.
the number of records is limited only by limits of your
hardware ie disc size, memory ect.
specification lists other limits like 1 gig max db size
which would include all objects in the db.