ADODB Object
 
Syntax
 
recordobject.Close
 
Description
Closes a Record object.
 
The Close method is used to close a Record object. As a consequence, you also lose access to any associated data.
 
Closing a Record object does not delete it from memory. You can later use the Open method to reopen the same Record, with or without the same properties. If you have closed an object and you no longer need it, you can set it equal to Nothing which will remove it from memory.
 
Calling the Close method while an edit is in process will generate an error. You should first call the Update or CancelUpdate methods.
See Also
Connection.Close, Open, Recordset.Close, Stream.Close.
Example
 
If objRecord.State = adStateOpen Then
   objRecord.Close
End If
Set objRecord = Nothing