Dynaset-Type Recordset Object Summary

 

The dynaset-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


Cancel

daoodbc

CancelUpdate


Clone

jet

Close


CopyQueryDef

jet

Delete


Edit


FillCache

jet

FindFirst

jet

FindLast

jet

FindNext

jet

FindPrevious

jet

GetRows


Move


MoveFirst


MoveLast


MoveNext


MovePrevious


NextRecordset

daoodbc

OpenRecordset

jet

Requery


Update


 

Properties

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

roRead-only

rwRead/write

Properties

Restrictions

AbsolutePosition

rw

BatchCollisionCount

rodaoodbc

BatchCollisions

rodaoodbc

BatchSize

rwdaoodbc

BOF

ro

Bookmark

rw

Bookmarkable

ro

CacheSize

rw Microsoft Jet

ro ODBCDirect

CacheStart

rwjet

Connection

rwdaoodbc

EditMode

ro

EOF

ro

Filter

rwjet

LastModified

ro

LockEdits

rwjet

rodaoodbc

Name

ro

NoMatch

rojet

PercentPosition

rw

RecordCount

ro

RecordStatus

rodaoodbc

Restartable

ro

Sort

rwjet

StillExecuting

rodaoodbc

Transactions

rojet

Type

ro

Updatable

ro

UpdateOptions

rwdaoodbc

ValidationRule

rojet

ValidationText

rojet