Close Method

Terminates working with the object.

Applies to objects: Connection, Database, QueryDef, Recordset, Workspace.

Syntax

object.Close()

The MethodName method syntax has these parts:

Part Description
object Required. A reference to an instance of the object.

Remarks

For the Recordset object the Close method closes the pointer and releases the memory, alloted for the records. For the Connection, Database, Workspace objects in closes the transaction.

For re-using a previously opened object you need to call the OpenConnection, OpenDatabase, OpenRecordset, CreateQueryDef, CreateWorkspace methods.

Example

.......

 

See Also

Connection Object, Database Object, QueryDef Object, Recordset Object, Workspace Object, CreateQueryDef Method, CreateWorkspace Method, OpenConnection Method, OpenDatabase Method, OpenRecordset Method.