Recordset Object, Recordsets Collection Summary

   

Recordset Object

A Recordset object contains these collections, methods, and properties.

Legend:

Feature available in both Microsoft Jet and ODBCDirect workspaces.

Feature available in Microsoft Jet workspaces only.

Feature available in ODBCDirect workspaces only.

Collections

Fields (default)
Properties

Recordset Methods

The following table lists all of the Recordset methods, and shows which Recordset type supports each method, and whether the method is available in either a Microsoft Jet or ODBCDirect workspace, or both.

Method Table Dynaset Snapshot Forward-Only Dynamic
AddNew *
Cancel
CancelUpdate *
Clone
Close
CopyQueryDef
Delete *
Edit *
FillCache
FindFirst
FindLast
FindNext
FindPrevious
GetRows
Move Only with forward moves that don't use a bookmark offset
MoveFirst
MoveLast
MoveNext
MovePrevious
NextRecordset
OpenRecordset
Requery
Seek
Update *

* In an ODBCDirect workspace, a snapshot-type Recordset may be updatable, depending on the ODBC driver. The AddNew, Edit, Delete, Update, and CancelUpdate methods are only available on ODBCDirect snapshot-type Recordset objects if the ODBC driver supports updatable snapshots.

Recordset Properties

The following table indicates which properties apply to each type of Recordset object and whether the property setting is read/write, read-only, or always False in either Microsoft Jet or ODBCDirect databases.

Read-only

Read/write

Property Table Dynaset Snapshot Forward-Only Dynamic
AbsolutePosition
BatchCollisionCount
BatchCollisions
BatchSize
BOF
Bookmark
Bookmarkable
CacheSize for Microsoft Jet workspaces
for ODBCDirect workspaces
CacheStart
Connection
DateCreated
EditMode
EOF
Filter
Index
LastModified *
LastUpdated
LockEdits for Microsoft Jet workspaces for Microsoft Jet workspaces
for ODBCDirect workspaces for ODBCDirect workspaces
Name
NoMatch
PercentPosition
RecordCount
RecordStatus
Restartable False
Sort
StillExecuting
Transactions

Always False

Always False

Type
Updatable Always False in Microsoft Jet workspaces Always False in Microsoft Jet workspaces
in ODBCDirect workspaces * in ODBCDirect workspaces *
UpdateOptions
ValidationRule
ValidationText

*In an ODBCDirect workspace, a snapshot-type Recordset may be updatable, depending on the ODBC driver. The LastModified property is available, and the Updatable property is True only on ODBCDirect snapshot-type Recordset objects if the ODBC driver supports updatable snapshots.

Recordsets Collection

A Recordsets collection appears in each Connection and Database object, and contains this method and this property.

Method

Refresh

Property

Count