Snapshot-Type Recordset Object Summary

 

The snapshot-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 *

Clone

jet

Close


CopyQueryDef

jet

Delete

daoodbc *

Edit

daoodbc *

FindFirst

jet

FindLast

jet

FindNext

jet

FindPrevious

jet

GetRows


Move


MoveFirst


MoveLast


MoveNext


MovePrevious


NextRecordset

daoodbc

OpenRecordset

jet

Requery


Update

daoodbc *

 

* 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.

roRead-only

rwRead/write

Properties

Restrictions

AbsolutePosition

rw

BatchCollisionCount

rodaoodbc

BatchCollisions

rodaoodbc

BatchSize

rwdaoodbc

BOF

ro

Bookmark

rw

Bookmarkable

ro

CacheSize

rodaoodbc

Connection

rwdaoodbc

EditMode

ro

EOF

ro

Filter

rwjet

LastModified

rodaoodbc *

LockEdits

rwjet


rodaoodbc

Name

ro

NoMatch

rojet

PercentPosition

rw

RecordCount

ro

RecordStatus

rodaoodbc

Restartable

ro

Sort

rwjet

StillExecuting

rodaoodbc

Transactions

Always False jet

Type

ro

Updatable

Always False in Microsoft Jet workspaces; ro in ODBCDirect workspaces *

UpdateOptions

rwdaoodbc

ValidationRule

rojet

ValidationText

rojet

 

* 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.