Does "set DB = Nothing" mean the same as DB.close?? 1

[jackiev]

In VB6- programming with database objects,
what is the proper (safest, best) way to
close out from & release connection to a database?

I have seen it coded 2 ways:
Set rsRecord = Nothing
Set dbDatabase = Nothing
and
rsRecord.Close
dbDatabase.Close
Which is correct?
Or should it be all 4 statements to release properly?

 

[Adam95]

You should use all 4. First close the recordset, then the database, then set them both to nothing. This will free up alot of resources for you and your end users.

Hope this helps.

Adam