Looping Macros

[dbguru316]

I have a fairly complex macro that has several embedded macros that run many
times. The number of times each macro runs is based on the number of records
to go through. When the number of records is small, all is well. When the
number of records increases, the macro hangs, and never seems to complete the
process.

Its not a record issue. I suspect that its a memory leak, or a memory issue
with using macros. Does anyone know if Access releases memory only after a
macro is complete? I suspect what is happening is that each time the
embedded macros run its allocating memory until all memory is used, never
releasing memory until the entire macro is complete.

Any suggestions?