Access program not responding

[Guest]

I have programs that run large iterations opening and closing recordsets many
times during each iteration.

If i set a brek somewhere along the code the program runs fine regardless of
the amount of iterations but if I do not use the brek then the program stops
responding after a short while.

Can any one help me out and advise me what to do to work around this problem?.

Appreciate any comment

 

[Guest]

Hello Juan,

Is there a reason that you need to close and reopen the recordset with each
iteration? This doesn't seem very efficient. In any case, when you close the
recordset, are you setting the variable = Nothing, to destroy it?

Here are two KB articles that might be helpful in your case:

Memory Use Climbs with Multiple Recordsets Under a Single Jet
Session/Connection
http://support.microsoft.com/?id=247140

FIX: Virtual Memory Leak with Large Number of Concurrently Open Recordsets
http://support.microsoft.com/?id=312575


It would be a lot more helpful if you can provide the complete function.

Tom

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________


:

I have programs that run large iterations opening and closing recordsets many
times during each iteration.

If i set a brek somewhere along the code the program runs fine regardless of
the amount of iterations but if I do not use the brek then the program stops
responding after a short while.

Can any one help me out and advise me what to do to work around this problem?.

Appreciate any comment

 

[Larry Linson]

Check Help for DoEvents, which yields control to Windows for other events to
be processed. Also be sure after you close a Recordset that you opened, to
set it to Nothing to release the object variables resources back to Windows
(if you did not Open the recordset, or create the Object Variable, do not
Close it or set it to Nothing -- for example you should neither close nor
set to nothing a Form's Recordset or RecordsetClone.

Be sure to follow Tom's good advice, as well.

Larry Linson
Microsoft Access MVP