I have an Access 97 database and to retrieve 500 records it takes about 6 minutes. This way to slow!

I need to increase the speed of the query. I am using an Access database and I am using stricly code for my query no data control.


Can anyone tell me where I can find some usefull information on query speed? I have a problem that I must fix urgently or I am out of a job!!


If anyone has any strong suggestions on how to improve query speed then please let me know./..

Stevie