ADO: ActiveX Data Objects

Name

Recordset Object — (Versions 2.0, 2.1, 2.5, 2.6)

Synopsis

Dim recordset As ADODB.Recordset

The Recordset object represents a complete group of rows within a table or a group of records that have been returned from an executed command.

Collections

Fields

Contains multiple Field objects for the current Recordset object, one for each column in the Recordset object.

Properties

Contains characteristics specific to the Recordset object for the currently used provider.

Methods

AddNew

Creates a new record within the current Recordset object and sets it to the specified value.

Cancel

Cancels an asynchronous operation for the Recordset object.

CancelBatch

Cancels the currently pending batch update for the current Recordset object.

CancelUpdate

Cancels any changes to the current batch update made since the last AddNew or Update method calls.

Clone

Returns a clone of the current recordset.

Close

Closes a recordset and releases any resources used by it.

CompareBookmarks

Determines the position of two bookmarks in a recordset in relationship to one another.

Delete

Deletes specified records within the recordset.

Find

Moves the record pointer to a row within the current recordset that matches the single-column search criteria specified.

GetRows

Returns multiple records from an open Recordset object in the form of an array.

GetString

Returns the entire Recordset object as a String value.

Move

Moves the position of the record pointer within the desired Recordset object.

MoveFirst

Moves the record pointer to the first record ...