Access 2007 response time

This d开发者_开发百科atabase is linked to SQL tables. I used multiple queries to open duplicate forms because the different criteria. Then I tried creating the search criteria with macros in the where condition. Both ways are extremely slow.

Should this be handled through the "on Load" Even Procedure? With an If statement? to get the results of each query currently used.

From your question the key part that stood out as a potential problem area was the part about using macros in the WHERE clause. The problem with that is you will have to bring lots of records down the wire to your local computer to do the processing.

Its like ringing a car dealer and saying “I would like to by a red car and it has to fit in my garage” The dealer knows what red cars he has (index) but does not know anything about your garage so has to drive each car (record) to your house (computer) and try to fit it in your garage!

If you can move all the processing to the server it would help , so expanding on the car example you ring up and say “I want a red car that is no wider than 4’” The dealer can now just send the cars (records) that match that criteria to your house (computer).

That’s all the help I can be for now until more information is provided