Memory

The computers memory is piling up! resulting in out of memory.

I have closed all databse objects and recordsets and set them to nothing but this does not seem to reduce the memory.

Can any one assist?

Have you set things to Nothing when you have finished with them?

eg;

Set MyRecordset = Nothing

IF it gets worse as you run the code again & again, you may be using a control with a memory leak, like MSChart before VB SP6.

Otherwise, your code has a memory leak. For every

Set statement

there should be another

Set whatever = Nothing

at the end of the function.