Determine Objects state

[Curious George]

I have a signiciant amount of code that opens and closes
Database, Recordsets, Querydefs etc. Is there a way in
the code (at the end of each procedure) to write the a
statement that will list the objects and their state.

I am willing to use the immediate, locals or any window,
I just don't want to type in each object name to
determine the overall state.

I fear I have not closed and set all my objects to
nothing and am consuming resources and affecting my
performance.

 

[Bas Cost Budde]

I have a signiciant amount of code that opens and closes
Database, Recordsets, Querydefs etc. Is there a way in
the code (at the end of each procedure) to write the a
statement that will list the objects and their state.

I am willing to use the immediate, locals or any window,
I just don't want to type in each object name to
determine the overall state.

I fear I have not closed and set all my objects to
nothing and am consuming resources and affecting my
performance.

I don't think so.

As long as the object variables you use to open these databases,
recordsets and whatshamacallits are all local (dim'd in the procedure)
you shouldn't have to worry.

But, OTOH, close what you open, unset what you set, all from code; that
way you cannot mess up your memory.