Record limit in access

M

Mark

Hi,
What is maximum record limit in access database (in one table and all
tables)?
I have database which will have over 500.000 records in one table. Is this
too much for access?
I am beginner :)

Thanks in advance
 
D

Douglas J. Steele

There is no maximum number of rows. The only maximums Access has is the
total size of the MDB file cannot exceed 2 Gb (1 Gb in Access 97 and
earlier), and the size of a single record cannot exceed 2000 characters.

I've worked with tables having in excess of a million rows.
 
Top