How can I find open recordsets or other variables that should have been closed?

Is there a way to browse in the VB editor or run some code to help me
find any unwanted opend recordsets or open variables?

Thanks,

Tony

re: How can I find open recordsets or other variables that should have been closed?

On 28 Dec 2003 05:59:10 -0800, rollin33s@yahoo.com (Sean O) wrote:

Iterate over the Recordsets collection.
There is no general way to find open objects. The best strategy is
defensive programming: after you write a line of code to open an
object, first write the line(s) of cleanup code, then fill in the
blanks.

-Tom.
..
[color=blue]
>Is there a way to browse in the VB editor or run some code to help me
>find any unwanted opend recordsets or open variables?
>
>Thanks,
>
>Tony[/color]