how many records can be stored in an Access 2003 table?

  • Thread starter Thread starter Guest
  • Start date Start date
There is no limit as it depends on the number of fields and th field types.
The help in access on limits and sizes states this

Table Size 2 gigabyte minus the space needed for the system objects
 
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.
 
Back
Top