Tables

  • Thread starter Thread starter RAO
  • Start date Start date
RAO said:
What is the maximum number of records allowed in a table
in Access 2002?
Click to expand...

There is no "record limit" when using JET tables. The limit is on the
total size of the MDB file where the JET tables reside. For Access 2000
that limit is 2GB. Obviously then, the number of records allowed within
that limit varies with table design and what kind of data is being stored.
 
Back
Top