ADO and SQL Server

Preserve on Abort Property

The Preserve on Abort property specifies whether a recordset remains active after a transaction is aborted.

Applies To
Command Object Recordset Object

Syntax

object.Properties("Preserve on Abort") [= 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 aborting a transaction, the recordset remains active. Therefore, it is possible to fetch new rows, update, delete, and insert rows, and so on.
False After aborting 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_ABORTPRESERVE

Remarks

Preserve on Abort applies only to local transactions.

See Also

Prepare Abort Behavior Property

Prepare Commit Behavior Property

Preserve on Commit Property