SQL Closing question

[s1police]

When I would like to close the connection for my coding SQL, what is the different between the below 2 types,

1.
myRecordSet.Close

2.
Set myRecordSet = Nothing
Set myConnection = Nothing

Is the same closing method or there is some background meaning? Please help to clarify~~

Thank you.

 

[boblarson]

Closing the recordset is closing the recordset. Setting the variables equal to "Nothing" releases the memory space allocated to them in RAM.