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 |