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