Access Project (Make Faster)

Chris, I have this access project. I need to speed it up. If you look at frmmain when you click on the "Search" button it takes about 10 seconds to load. I would like to keep that under three seconds if possible. This program is running on 8 computers, but I am attaching a copy of the front end and back end information. On frmsearch it takes about 10- 15 seconds to run a search for a part. I would also like to keep that to a minimum(hopefully under three seconds as well.) I this is not possible tell me how much faster can you get it to work. Thank You. Danny. ## Deliverables 1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Installation package that will install the software (in ready-to-run condition) on the platform(s) specified in this bid request. 3) Exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement). ## Platform Windows 2000, xp, 9x, me