The Recordset Object  
A Recordset object represents the entire set of records from a base table or the results of an executed command. At any time, the Recordset object only refers to a single record within the set as the current record.
AddNew  
  Method
 
Creates a new record for an updateable Recordset object.
Cancel  
  Method
 
Cancels execution of a pending asynchronous Open operation.
CancelBatch  
  Method
 
Cancels a pending batch update.
CancelUpdate  
  Method
 
Cancels any changes made to the current record, or to a new record prior to calling the Update method.
Clone  
Returns: Recordset Method
 
Creates a duplicate Recordset object from and existing Recordset object.
Close  
  Method
 
Closes the Recordset object and any dependent objects.
CompareBookmarks  
Returns: Compare Enum Method
 
Compares two bookmarks and returns an indication of the relative values.
Delete  
  Method
 
Deletes the current record or group of records.
Find  
  Method
 
Searches the Recordset for a record that matches the specified criteria.
GetRows  
Returns: Variant Method
 
Retrieves multiple records of a Recordset object into an array.
GetString  
Returns: String Method
 
Returns a Recordset as a string.
Move  
  Method
 
Moves the recordset cursor to point at a Recordset.
MoveFirst  
  Method
 
Moves the recordset cursor to point at the first record in the Recordset.
MoveLast  
  Method
 
Moves the recordset cursor to point at the last record in the Recordset.
MoveNext  
  Method
 
Moves the recordset cursor to point at the next record in the Recordset.
MovePrevious  
  Method
 
Moves the recordset cursor to point at the previous record in the Recordset.
NextRecordset  
Returns: Recordset Method
 
Clears the current Recordset object and returns the next Recordset by advancing through a series of commands.
Open  
  Method
 
Opens a Recordset.
Requery  
  Method
 
Updates the data in a Recordset object by re-executing the query on which the object is based.
Resync  
  Method
 
Refreshes the data in the current Recordset object from the underlying database.
Save  
  Method
 
Saves the Recordset to a file.
Seek  
  Method
 
Searches the recordset index to locate a value
Supports  
Returns: Boolean Method
 
Determines whether a specified Recordset object supports particular functionality.
Update  
  Method
 
Saves any changes made to the current Recordset object.
UpdateBatch  
  Method
 
Writes all pending batch updates to disk.
AbsolutePage  
Returns: PositionEnum Property
 
Specifies in which page the current record resides.
AbsolutePosition  
Returns: PositionEnum Property
 
Specifies the ordinal position of a Recordset object's current record.
ActiveCommand  
Returns: Object Property
 
Indicates the Command object that created the associated Recordset object. Read only.
ActiveConnection  
Returns: Variant Property
 
Indicates to which Connection object the specified Recordset object currently belongs.
BOF  
Returns: Boolean Property
 
Indicates whether the current record is before the first record in a Recordset object. Read only.
Bookmark  
Returns: Variant Property
 
Returns a bookmark that uniquely identifies the current record in a Recordset object, or sets the current record to the record identified by a valid bookmark.
CacheSize  
Returns: Long Property
 
Indicates the number of records from a Recordset object that are cached locally in memory.
CursorLocation  
Returns: CursorLocation Enum Property
 
Sets or returns the location of the cursor engine.
CursorType  
Returns: CursorType Enum Property
 
Indicates the type of cursor used in a Recordset object.
DataMember  
Returns: String Property
 
Specifies the name of the data member to retrieve from the object referenced by the DataSource property. Write only.
DataSource  
Returns: Object Property
 
Specifies an object containing data to be represented as a Recordset object. Write only.
EditMode  
Returns: EditModeEnum Property
 
Indicates the editing status of the current record. Read only.
EOF  
Returns: Boolean Property
 
Indicates whether the current record is after the last record in a Recordset object. Read only.
Fields  
Returns: Fields Property
 
Contains all of the Field objects for the current Recordset object.
Filter  
Returns: Variant Property
 
Indicates a filter for data in the Recordset.
Index  
Returns: String Property
 
Identifies the name of the index currently being used.
LockType  
Returns: LockTypeEnum Property
 
Indicates the type of locks placed on records during editing.
MarshalOptions  
Returns: MarshalOptions Enum Property
 
Indicates which records are to be marshaled back to the server.
MaxRecords  
Returns: Long Property
 
Indicates the maximum number of records to return to a Recordset object from a query. Default is zero (no limit).
PageCount  
Returns: Long Property
 
Indicates how many pages of data the Recordset object contains. Read only.
PageSize  
Returns: Long Property
 
Indicates how many records constitute one page in the Recordset.
Properties  
Returns: Properties Property
 
Contains all of the Property objects for the current Recordset object.
RecordCount  
Returns: Long Property
 
Indicates the current number of records in the Recordset object. Read only.
Sort  
Returns: String Property
 
Specifies one or more field names the Recordset is sorted on, and the direction of the sort.
Source  
Returns: String Property
 
Indicates the source for the data in a Recordset object.
State  
Returns: Long Property
 
Indicates whether the recordset is open, closed, or whether it is executing an asynchronous operation. Read only.
Status  
Returns: Integer Property
 
Indicates the status of the current record with respect to match updates or other bulk operations. Read only.
StayInSync  
Returns: Boolean Property
 
Indicates, in a hierarchical Recordset object, whether the parent row should change when the set of underlying child records changes. Read only.
EndOfRecordset  
  Event
 
Fired when there is an attempt to move to a row past the end of the Recordset.
FetchComplete  
  Event
 
Fired after all the records in an asynchronous operation have been retrieved into the Recordset.
FetchProgress  
  Event
 
Fired periodically during a lengthy asynchronous operation, to report how many rows have currently been retrieved.
FieldChangeComplete  
  Event
 
Fired after the value of one or more Field objects have been changed.
MoveComplete  
  Event
 
Fired after the current position in the Recordset changes.
RecordChangeComplete  
  Event
 
Fired after one or more records change.
RecordsetChangeComplete  
  Event
 
Fired after the Recordset has changed.
WillChangeField  
  Event
 
Fired before a pending operation changes the value of one or more Field objects.
WillChangeRecord  
  Event
 
Fired before one or more rows in the Recordset change.
WillChangeRecordset  
  Event
 
Fired before a pending operation changes the Recordset.
WillMove  
  Event
 
Fired before a pending operation changes the current position in the Recordset.