Snapshot-Type Recordset Object Summary

   

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

Legend:

   Feature available in Microsoft Jet workspaces only.

   Feature available in ODBCDirect workspaces only.

Collections

Fields (default)
Properties

Methods Restrictions
AddNew *
Cancel
CancelUpdate *
Clone
Close  
CopyQueryDef
Delete *
Edit *
FindFirst
FindLast
FindNext
FindPrevious
GetRows  
Move
MoveFirst
MoveLast
MoveNext
MovePrevious
NextRecordset
OpenRecordset
Requery  
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.

Properties

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

   Read-only

   Read/write

Properties Restrictions
AbsolutePosition
BatchCollisionCount
BatchCollisions
BatchSize
BOF
Bookmark
Bookmarkable
CacheSize
Connection
EditMode
EOF
Filter
LastModified *
LockEdits
 
Name
NoMatch
PercentPosition
RecordCount
RecordStatus
Restartable
Sort
StillExecuting
Transactions Always False
Type
Updatable Always False in Microsoft Jet 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.