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

Closing objects vs setting to nothing

P: n/a
Hi,

I am hoping somebody can provide a clear picture on this topic. When
is it necessary to specifically close and/or set an object (recordset,
database, variable, etc.)to nothing and what is the main difference
between closing the object and setting them to nothing.

I've read several articles that Access may not release some resources
if you don't force it to, so I'm just wondering which of the two
(setting them to nothing or closing them or both) causes Access to
release the resources.

I'm also wondering if anybody knows in what cases Access doesn't
release them as I understand that most of the time they will
automatically be released when the sub or function is ended.

I would appreciate any guidance in this area that anybody has.

Thank you,
Ryan
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
"Deano" <ma************@hotmail.com> wrote in message news:<v7*******************@wards.force9.net>...
Ryan wrote:
Hi,

I am hoping somebody can provide a clear picture on this topic. When
is it necessary to specifically close and/or set an object (recordset,
database, variable, etc.)to nothing and what is the main difference
between closing the object and setting them to nothing.

I've read several articles that Access may not release some resources
if you don't force it to, so I'm just wondering which of the two
(setting them to nothing or closing them or both) causes Access to
release the resources.

I'm also wondering if anybody knows in what cases Access doesn't
release them as I understand that most of the time they will
automatically be released when the sub or function is ended.

I would appreciate any guidance in this area that anybody has.

Thank you,
Ryan


Big thread on this a while back which was pretty comprehensive;

http://makeashorterlink.com/?K3F715EE5

Thank you for the link. That was just what I needed. I didn't find
much of anything before I posted this message, but now I see countless
articles on this subject. Must not have been searching correctly I
guess. Thanks again

Ryan
Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.