Memory

[caddick98]

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?

[Buzby]

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

eg;

Set MyRecordset = Nothing

[jim mcnamara]

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.