Table size limitations

  • Thread starter Thread starter Chris Roche
  • Start date Start date
C

Chris Roche

I inherited a predefined Access 2000 database from
another individual and was wondering what the maximum
record count for a single table is. Within the database
there is one table that currently has 2,239,753 records
in it. Is there a maximum? I'm having problems with
reporting that I believe may related to the table size.
The next largest table only has 170,000 records in in.
 
There is no explicit limit on record count, but with that many, you really
want to make sure your indexes and queries are set up properly. More
records returned and in the base tables is going to take longer (of course)

--
Kevin Hill
President
3NF Consulting

www.3nf-inc.com/NewsGroups.htm
 
Back
Top