Access' limits

[Tarek Agguerabi]

Hello!

is there a limit in number of records to a table in MS Access?
how far can it store?

Thanks!

 

[Van T. Dinh]

There is a limit on the size of the database file (1 GB
for A97, 2 GB for A2K and AXP). You can also use linked
Tables to increase the total size.

Tpye "specification" in Access Help Index to get other
limits.

HTH
Van T. Dinh
MVP (Access)