Loop through all open objects

[guitardave78]

Is it possible to loop through all open objects and close them ?

The background is I have inherited a system where record sets never get closed. I don not yet have time to hard code this in. For now I would like to loop through any open object and kill it!!

}...the bane of my life!

http://www.yetanotherreviewsite.co.uk

http://www.fuzzyd.co.uk

 

[Chopstik]

So you want to know if an object is open and, if so, then close it automatically? I am not aware of a way to have the application check for any open objects and close them automatically (sounds like the destructor or garbage collector in .NET). But if I'm wrong, please clarify.

------------------------------------------------------------------------------------------------------------------------
"Men occasionally stumble over the truth, but most of them pick themselves up and hurry off as if nothing ever happened."
- Winston Churchill

 

[guitardave78]

No that is it

}...the bane of my life!

http://www.yetanotherreviewsite.co.uk

http://www.fuzzyd.co.uk

 

[Chopstik]

The MS KnowledgeBase indicates that there is currently no garbage collection for VBScript. However, if you use JScript, there may be some hope... Sorry... :-(

------------------------------------------------------------------------------------------------------------------------
"Men occasionally stumble over the truth, but most of them pick themselves up and hurry off as if nothing ever happened."
- Winston Churchill

 

[guitardave78]

Is there a way to see what recordsets are in memory using the adodb object?


}...the bane of my life!

http://www.yetanotherreviewsite.co.uk

http://www.fuzzyd.co.uk