DevGuru ADO Record::Close Method

Quick References

Features

Partners



			METHOD: Record::Close Implemented in version 2.5 recordobject.Close 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. Code (VBScript): If objRecord.State = adStateOpen Then objRecord.Close End If Set objRecord = Nothing