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