colinramsay.co.uk

Microsoft Access Web Table Row Limits

14 Jul 2004

When using Access as the database for a website, I've stumbled upon an issue - there appears to be some kind of performance threshold at around 9000 records. If there are more than 9000 records in a single table, performance for the entire database just goes to shit...

I would be surprised to find that this is a genuine limitation of Access. I suspect it is more a problem with my code or the database setup. Still, the interim solution is to remove 3000 old records from that table.

Feedback or questions on this post? Create an issue on GitHub.