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,
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,