Recordset Object

You use Recordset objects to manipulate data from the provider. When you use ADO, you manipulate data almost entirely using Recordset objects. All Recordset objects consist of records (rows) and fields (columns).

In addition to the standard ADO properties, these dynamic properties are added to the Properties collection of the Recordset object.

Dynamic Properties

Access Order Property	Notification Granularity Property
Blocking Storage Objects Property	Notification Phases Property
Bookmark Type Property	Objects Transacted Property
Bookmarkable Property	Others' Changes Visible Property
Change Inserted Rows Property	Others' Inserts Visible Property
Column Privileges Property	Own Changes Visible Property
Column Set Notification Property	Own Inserts Visible Property
Command Time Out Property	Preserve on Abort Property
Defer Column Property	Preserve on Commit Property
Delay Storage Object Updates Property	Quick Restart Property
Fetch Backwards Property	Reentrant Events Property
Hold Rows Property	Remove Deleted Rows Property
IAccessor Property	Report Multiple Changes Property
IColumnsInfo Property	Return Pending Inserts Property
IColumnsRowset Property	Row Delete Notification Property
IConnectionPointContainer Property	Row First Change Notification Property
IConvertType Property	Row Insert Notification Property
Immobile Rows Property	Row Privileges Property
IRowset Property	Row Resynchronization Notification Property
IRowsetChange Property	Row Threading Model Property
IRowsetIdentity Property	Row Undo Change Notification Property
IRowsetInfo Property	Row Undo Delete Notification Property
IRowsetLocate Property	Row Undo Insert Notification Property
IRowsetResynch Property	Row Update Notification Property
IRowsetScroll Property	Rowset Fetch Position Change Notification Property
IRowsetUpdate Property	Rowset Release Notification Property
ISequentialStream Property	Scroll Backwards Property
ISupportErrorInfo Property	Server Cursor Property
Literal Bookmarks Property	Skip Deleted Bookmarks Property
Literal Row Identity Property	Strong Row Identity Property
Maximum Open Rows Property	Unique Rows Property
Maximum Pending Rows Property	Updatability Property
Maximum Rows Property	Use Bookmarks Property