When should objects be closed and/or variables cleared?

[MS]

When is it appropriate to "close" objects?

Example. Which of these objects should be "closed"?

Dim Wsp as Workspace
Dim Dbf as DataBase
Dim Rstb as Recordset
Dim Tdf As TableDef
Dim Cdb As DataBase

Set Wsp = DBEngine.Worksp aces(0)
Set Dbf = Wsp.OpenDatabas e(path & "DatabaseName.m db")
Set Rstb = Dbf.OpenRecords et("TblInfo", dbOpenDynaset)
Set Cdb = CurrentDb

Normally, I just "close" the database object like this.....

Set Dbf = Nothing or Set Cdb = Nothing

Is that sufficient? Is it the correct way?

Is it the same as this?
Dbf.close

Should I be setting them all to "nothing"?
Set Wsp = Nothing
Set Rstb = Nothing
Set Dbf = Nothing
Set Cdb = Nothing
Set Tdf = Nothing

Should they all be "closed"?
Wsp.Close
Rstb.Close
Dbf.Close
Cdb.Close
Tdf .Close

By not setting them all to nothing, or by not "closing" them all, am I
wasting memory?
Thanks for any help!

[Scott McDaniel]

In General - If you Open in, then Close it ... If you Set = Something, then
Set = Nothing

So you would
Set Wsp = Nothing
dbf.Close
Set dbf = Nothing
rstb.Close
Set rstb = Nothing
Set tdf = Nothing
Set cbd = Nothing

FWIW, most "cleanup" code you see simply sets object vars = Nothing. From
what I've been able to gather from newsgroup postings, Closing object
variables was much more critical in 97 than in later versions of Access. I
could be misled about this, howver, and I've always just followed the old
advice at the top of this post ... if I open it, I close it and if I Set it,
I Set=Nothing.

"MS" <Em***@Myemail. com> wrote in message
news:gd******** ********@news-server.bigpond. net.au...

When is it appropriate to "close" objects?

Example. Which of these objects should be "closed"?

Dim Wsp as Workspace
Dim Dbf as DataBase
Dim Rstb as Recordset
Dim Tdf As TableDef
Dim Cdb As DataBase

Set Wsp = DBEngine.Worksp aces(0)
Set Dbf = Wsp.OpenDatabas e(path & "DatabaseName.m db")
Set Rstb = Dbf.OpenRecords et("TblInfo", dbOpenDynaset)
Set Cdb = CurrentDb

Normally, I just "close" the database object like this.....

Set Dbf = Nothing or Set Cdb = Nothing

Is that sufficient? Is it the correct way?

Is it the same as this?
Dbf.close

Should I be setting them all to "nothing"?
Set Wsp = Nothing
Set Rstb = Nothing
Set Dbf = Nothing
Set Cdb = Nothing
Set Tdf = Nothing

Should they all be "closed"?
Wsp.Close
Rstb.Close
Dbf.Close
Cdb.Close
Tdf .Close

By not setting them all to nothing, or by not "closing" them all, am I
wasting memory?
Thanks for any help!