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

 

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.

 

* 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

 

*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

 

Property