Table size limitations

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.
 
K

Kevin3NF

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

About Access limits 15
Hitting the limits with large table in Excel containing 1 millionrecords. What is the best option fo 2
Add autonumber to a large table? 0
Access limitations? 6
Maximum record size and maximum number of records 3
How big can an Access table be? 5
Finding size of database 2
Excel Returning Multiple Results (closest Match Not Exact) From A Table Using Multiple Criteria 1

Top