Record limits in Access

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

What are the maximum number of records that Access 2003 can have?
I believe this is related to memory size. If so, what is the formula.
 
Hi,

The help facility does not really give you information to calculate max
number of records. There is no formula and there is no max number of
records.

An Access database can be up to 2GB in size (however many records get you
there). Also, by using link tables you can circumvent this size limitation,
since you can link to multiple Access databases.

HTH,
Immanuel Sibero
 
Back
Top