[bly]

I assume you're using ACCESS and haven't converted to Postgres SQL?

Do yourself a favor, at least get up to Postgres.

Or ever better, get a second PC, something in the $600 range, setup a small network, and run Postgres on the second PC. Puts 99% of the load on another CPU. I have 500k+ hands in my DB and 8 table without issues this way.