The more invoices I made, the slower the program is

[clarocque]

I don't know if I need to post the code for that because the code seems ok, the problem is at the first order of the day, the program is running fast, at the second order it takes 5 seconds more, at the 10th order it takes 30 seconds more and so on.
It seems that the memory is not clearing or reset or something of that matter.

How can I empty the memory after each order.

Thanks



Claude from Quebec, Canada

[CJ_London]

not enough information to advise., but so far as I am aware the only way to clear the memory is to close access.

I doubt memory per se is the issue, more likely something to do with your code and/or design. Are tables normalised and properly indexed? are you making extensive use of domain functions? (you shouldn't). Is your code creating large in memory recordsets and/or arrays which are not being cleared down? or are larger than they need to be and need filtering? is your network slow?