Feature available in Microsoft Jet workspaces only.
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.