By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,483 Members | 1,449 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,483 IT Pros & Developers. It's quick & easy.

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

P: n/a
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
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
On 28 Dec 2003 05:59:10 -0800, ro*******@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.
..
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


Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.