Open Method Connection Close Method Recordset Close Method Stream Close Method 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 Copyright 1999-2001 by Infinite Software Solutions, Inc. All rights reserved. Trademark Information