Forward-Only–Type Recordset Object Summary

 

The forward-only type Recordset object contains these collections, methods, and properties.

Legend:

jetFeature available in Microsoft Jet workspaces only.

daoodbcFeature available in ODBCDirect workspaces only.

Collections

Fields (default)

Properties

 

Methods

Restrictions

AddNew

daoodbc

Cancel

daoodbc

CancelUpdate

daoodbc

Close


CopyQueryDef

jet

Delete

daoodbc

Edit

daoodbc

GetRows


Move

Only with forward moves that don't use a bookmark offset.

MoveNext


NextRecordset

daoodbc

Requery


Update

daoodbc

 

Properties

The following table indicates whether each property setting is read/write, read-only, or always False in either Microsoft Jet or ODBCDirect workspaces.

roRead-only

rwRead/write

Properties

Restrictions

BatchCollisionCount

rodaoodbc

BatchCollisions

rodaoodbc

BatchSize

rwdaoodbc

BOF

ro

Connection

rwdaoodbc

EOF

ro

Filter

rwjet

Name

ro

RecordCount

ro

RecordStatus

rodaoodbc

Restartable

ro

StillExecuting

rodaoodbc

Transactions

Always False jet

Type

ro

Updatable

False jet

UpdateOptions

rwdaoodbc

ValidationRule

rojet

ValidationText

rojet