Determine Objects state

  • Thread starter Thread starter Curious George
  • Start date Start date
C

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.
 
Curious said:
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.
Click to expand...

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.
 
Back
Top