Hello Dennis, Try this:

Just after rstX.Close add ' Set rstX = Nothing '
Setting to nothing sholud clear the memory.

Ofcourse between the multiple calls you have to Set it again to valid
RecordSet, and I guess, this must be there already in your code for each
call.

Sharad

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!