Recordset Members (DAO)

AddNew

Creates a new record for an updatable Recordset object.

Cancel

Note
ODBCDirect workspaces are not supported in Microsoft Access 2013. Use ADO if you want to access external data sources without using the Microsoft Access database engine.

Cancels execution of a pending asynchronous method call (ODBCDirect workspaces only).

CancelUpdate

Cancels any pending updates for a Recordset object.

Clone

Creates a duplicate Recordset object that refers to the original Recordset object.

Close

Closes an open Recordset.

CopyQueryDef

Returns a QueryDef object that is a copy of the QueryDef used to create the Recordset object represented by the recordset placeholder (Microsoft Access workspaces only). .

Delete

Not supported for this object.

Edit

Copies the current record from an updatable Recordset object to the copy buffer for subsequent editing.

FillCache

Fills all or a part of a local cache for a Recordset object that contains data from a Microsoft Access database engine-connected ODBC data source (Microsoft Access database engine-connected ODBC databases only).

FindFirst

Locates the first record in a dynaset- or snapshot-type Recordset object that satisfies the specified criteria and makes that record the current record (Microsoft Access workspaces only).

FindLast

Locates the last record in a dynaset- or snapshot-type Recordset object that satisfies the specified criteria and makes that record the current record (Microsoft Access workspaces only).

FindNext

Locates the next record in a dynaset- or snapshot-type Recordset object that satisfies the specified criteria and makes that record the current record (Microsoft Access workspaces only). .

FindPrevious

Locates the previous record in a dynaset- or snapshot-type Recordset object that satisfies the specified criteria and makes that record the current record (Microsoft Access workspaces only). .

GetRows

Retrieves multiple rows from a Recordset object.

Move

Moves the position of the current record in a Recordset object.

MoveFirst

Moves to the first record in a specified Recordset object and make that record the current record.

MoveLast

Moves to the last record in a specified Recordset object and make that record the current record.

MoveNext

Moves to the next record in a specified Recordset object and make that record the current record.

MovePrevious

Moves to the previous record in a specified Recordset object and make that record the current record.

NextRecordset

Note
ODBCDirect workspaces are not supported in Microsoft Access 2013. Use ADO if you want to access external data sources without using the Microsoft Access database engine.

Gets the next set of records, if any, returned by a multi-part select query in an OpenRecordset call, and returns a Boolean value indicating whether one or more additional records are pending (ODBCDirect workspaces only).

OpenRecordset

Creates a new Recordset object and appends it to the Recordsets collection.

Requery

Updates the data in a Recordset object by re-executing the query on which the object is based.

Seek

Locates the record in an indexed table-type Recordset object that satisfies the specified criteria for the current index and makes that record the current record (Microsoft Access workspaces only).

Update

Note
ODBCDirect workspaces are not supported in Microsoft Access 2013. Use ADO if you want to access external data sources without using the Microsoft Access database engine.

Saves the contents of the copy buffer to an updatable Recordset object.

AbsolutePosition

Sets or returns the relative record number of a Recordset object's current record.

BatchCollisionCount

Note
ODBCDirect workspaces are not supported in Microsoft Access 2013. Use ADO if you want to access external data sources without using the Microsoft Access database engine.

Returns the number of records that did not complete the last batch update (ODBCDirect workspaces only).

BatchCollisions

Note
ODBCDirect workspaces are not supported in Microsoft Access 2013. Use ADO if you want to access external data sources without using the Microsoft Access database engine.

Returns an array of bookmarks indicating the rows that generated collisions in the last batch update operation (ODBCDirect workspaces only).

BatchSize

Note
ODBCDirect workspaces are not supported in Microsoft Access 2013. Use ADO if you want to access external data sources without using the Microsoft Access database engine.

Sets or returns the number of statements sent back to the server in each batch (ODBCDirect workspaces only).

BOF

Returns a value that indicates whether the current record position is before the first record in a Recordset object. Read-only Boolean.

Bookmark

Sets or returns a bookmark that uniquely identifies the current record in a Recordset object.

Bookmarkable

Returns a value that indicates whether a Recordset object supports bookmarks, which you can set by using the Bookmark property.

CacheSize

Sets or returns the number of records retrieved from an ODBC data source that will be cached locally. Read/write Long.

CacheStart

Sets or returns a value that specifies the bookmark of the first record in a dynaset-type Recordset object containing data to be locally cached from an ODBC data source (Microsoft Access workspaces only).

Connection

Returns the Connection object that corresponds to the database.

DateCreated

Returns the date and time a base table was created (Microsoft Access workspaces only). Read-only Variant.

EditMode

Returns a value that indicates the state of editing for the current record.

EOF

Returns a value that indicates whether the current record position is after the last record in a Recordset object. Read-only Boolean.

Fields

Returns a Fields collection that represents all stored Field objects for the specified object. Read-only.

Filter

Sets or returns a value that determines the records included in a subsequently opened Recordset object (Microsoft Access workspaces only). Read/write String.

Index

Sets or returns a value that indicates the name of the current Index object in a table-type Recordset object (Microsoft Access workspaces only).

LastModified

Returns a ookmark indicating the most recently added or changed record.

LastUpdated

Returns the date and time of the most recent change made to a base table. Read-only Variant.

LockEdits

Sets or returns a value indicating the type of locking that is in effect while editing.

Name

Returns the name of the specified object. Read-only String.

NoMatch

Indicates whether a particular record was found by using the Seek method or one of the Find methods (Microsoft Access workspaces only).

PercentPosition

Sets or returns a value indicating the approximate location of the current record in the Recordset object based on a percentage of the records in the Recordset.

Properties

Returns the Properties collection of the specified object. Read-only.

RecordCount

Returns the number of records accessed in a Recordset object, or the total number of records in a table-type Recordset object. or TableDef object. Read-only Long.

RecordStatus

Note
ODBCDirect workspaces are not supported in Microsoft Access 2013. Use ADO if you want to access external data sources without using the Microsoft Access database engine.

Returns a value indicating the update status of the current record if it is part of a batch update (ODBCDirect workspaces only). Read-only RecordStatusEnum.

Restartable

Returns a value that indicates whether a Recordset object supports the Requery method, which re-executes the query on which the Recordset object is based.

Sort

Sets or returns the sort order for records in a Recordset object (Microsoft Access workspaces only).

StillExecuting

Note
ODBCDirect workspaces are not supported in Microsoft Access 2013. Use ADO if you want to access external data sources without using the Microsoft Access database engine.

Indicates whether or not an asynchronous operation (that is, a method called with the dbRunAsync option) has finished executing (ODBCDirect workspaces only).

Transactions

Returns a value that indicates whether an object supports transactions. Read-only Boolean.

Type

The description for this member will appear in the final release of Office 14.

Updatable

Returns a value that indicates whether you can change a DAO object. Read-only Boolean.

UpdateOptions

Note
ODBCDirect workspaces are not supported in Microsoft Access 2013. Use ADO if you want to access external data sources without using the Microsoft Access database engine.

Sets or returns a value that indicates how the WHERE clause is constructed for each record during a batch update, and whether the batch update should use an UPDATE statement or a DELETE followed by an INSERT (ODBCDirect workspaces only). Read/write UpdateCriteriaEnum.

ValidationRule

Sets or returns a value that validates the data in a field as it's changed or added to a table (Microsoft Access workspaces only).Read/write String.

ValidationText

Sets or returns a value that specifies the text of the message that your application displays if the value of a Field object doesn't satisfy the validation rule specified by the ValidationRule property setting (Microsoft Access workspaces only). Read-only String.