Another aproach would be to switch your database backend. This isn't as bad an answer as you might think, though it isn't always an option. I have had great success in moving the data out of MS Access into MySQL tables using the export wizard that comes with Access. Then you can still use Access for forms and reports, but your data sits in an easily available MySQL server. I've found that if you link to the MySQL tables inside your db file then even 3rd party applications that use the db file will now be using your MySQL backend without even knowing it. In many cases this can provide a great speed boost with minor work. Just my 2 cents.