John, here are a couple of things that you can try:

1. Compact your program if you have not done so already.

2. Decompile your program. You may have some old code that is
slowing you down. Decompile will get rid of all of the "ghost" code.
Here's the syntax: msaccess.exe /decompile "c:\database.mdb". However,
please read this article before doing:
http://www.mvps.org/access/bugs/bugs0008.htm for precautions and
cautions.

3. Be sure you have indexes on the important data elements in your
tables. This can make a dramatic difference in speed.

Good luck.
Terri