Max Tabel size

  • Thread starter Thread starter Len
  • Start date Start date
Hi,
Does anyone know the max table size in access2000.
thanks
Len
Click to expand...

See "Specifications" in the online help.

There is no explicit table size limit; a single .mdb file (or .adp
project) is limited to 2 gigabytes, so the combination of all the
objects in a single file cannot exceed that limit.

In practice, if you have over 10,000,000 records in a table you should
be seriously thinking about moving to a client-server database.
 
Back
Top