The snapshot-type Recordset object contains these collections, methods, and properties.
Legend:
Feature available in Microsoft Jet workspaces only.
Feature available in ODBCDirect workspaces only.
Collections
Fields (default) |
Properties |
Methods | Restrictions |
AddNew | * |
Cancel | |
CancelUpdate | * |
Clone | |
Close | |
CopyQueryDef | |
Delete | * |
Edit | * |
FindFirst | |
FindLast | |
FindNext | |
FindPrevious | |
GetRows | |
Move | |
MoveFirst | |
MoveLast | |
MoveNext | |
MovePrevious | |
NextRecordset | |
OpenRecordset | |
Requery | |
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.
Properties
The following table indicates whether the property setting is read/write, read-only, or always False in either Microsoft Jet or ODBCDirect workspaces.
Read-only
Read/write
Properties | Restrictions |
AbsolutePosition | |
BatchCollisionCount | |
BatchCollisions | |
BatchSize | |
BOF | |
Bookmark | |
Bookmarkable | |
CacheSize | |
Connection | |
EditMode | |
EOF | |
Filter | |
LastModified | * |
LockEdits | |
Name | |
NoMatch | |
PercentPosition | |
RecordCount | |
RecordStatus | |
Restartable | |
Sort | |
StillExecuting | |
Transactions | Always False |
Type | |
Updatable | Always False in Microsoft Jet 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.