ADO » Record » Close

Version: 2.5


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.


If objRecord.State = adStateOpen Then
End If
Set objRecord = Nothing

See Also: