access function runs slower afer being run multiple times

meadt

Registered User.
Local time
Today, 07:27
Joined
Oct 29, 2009
Messages
45
Hi Guys,
I have a database that works on quite an involved function.
Ive found that when I run this function over and over again it slows down conciderably. The only way to speed it up again is to close access and open it again. Theres even a marked difference in speed between the first time I run it and the second. Not sure what is causing this but would like to know as well as ways to solve it. Is the memory not clearing properly?

Thanks for any advice,
 

Users who are viewing this thread

Back
Top Bottom