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.