View Full Version : SQL Closing question


s1police
10-11-2007, 06:22 PM
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
10-11-2007, 06:26 PM
Closing the recordset is closing the recordset. Setting the variables equal to "Nothing" releases the memory space allocated to them in RAM.