Can running a macro eat up memory?

[KHerm]

I've been trying to get a macro to run a series of query scripts and functions. When I do the steps by hand, everything runs fine. However, I have one function that seems to go on forever when it's run from the macro. Do I need to put some memory clearing code at the end of functions? I've been ending my functions with:

set dbs = nothing

but maybe I need to do more?

Thanks for any help.

Ken

 

[lameid]

Close and set objects to nothing as applicable as soon and possible and move any recordsets that are for read only purposes out of transactions. Beyond that, I think we need to see your code.