ADO and SQL Server

Preserve on Commit Property

The Preserve on Commit property specifies whether a recordset remains active after a transaction is committed.

Applies To
Command Object Recordset Object

Syntax

object.Properties("Preserve on Commit") [= value]

Parts

object

Expression that evaluates to an object in the Applies To list.

value

Boolean that specifies whether a recordset remains active, as specified in Settings.

Settings
Value Description
True After committing a transaction, the recordset remains active. Therefore, it is possible to fetch new rows; update, delete, and insert rows; and so on.
False After committing a transaction, the only operations allowed on a recordset are to release rows and the recordset.

Data Type

adBoolean

Modifiable

Read/write

OLE DB Property

DBPROP_COMMITPRESERVE

Remarks

Preserve on Commit applies only to local transactions.

See Also

Prepare Abort Behavior Property

Prepare Commit Behavior Property

Preserve on Abort Property

Transaction DDL Property