If you need to close connections to conserve connection resources, you can complete the active statement on a connection. Active statements can usually be completed or cleared by retrieving the remaining records in the Recordset object containing the query results. The easiest way to complete a statement that has a pending retrieval operation is to use the MoveLast method of the Recordset object. This closes the active statement and releases the connection associated with the statement.
Note This technique is not recommended for very large Recordset objects.