Queries running very slow

[SKV]

Was able to run same queries in the past and they use to run fast but recently it is taking hell lot of time to run.

Any idea to improve the execution time? Do I need to clear memory or do something else?

Thanks
Sachin

 

[Joe4]

Have you tried Compacting and Repairing your database?
That will keep the database from being bloated and improve efficiency. IF you do a lot of deleting data from your databases, you should run this regularly.

 

[boblarson]

Was able to run same queries in the past and they use to run fast but recently it is taking hell lot of time to run.

Any idea to improve the execution time? Do I need to clear memory or do something else?

Thanks
Sachin

Also

1. What is the configuration of your database (FE/BE, single file, what)?

2. Where is the FE if you have a split Db? Does each user have a copy of the FE file?

3. What is your network like?

4. What version of Access (including Service Pack level)?

5. What version of Windows are you running?