IsolationLevelEnum
Applies to: Access 2013, Office 2013
Specifies the level of transaction isolation for a Connection object.
Constant |
Value |
Description |
|---|---|---|
adXactUnspecified |
-1 |
Indicates that the provider is using a different isolation level than specified, but that the level cannot be determined. |
adXactChaos |
16 |
Indicates that pending changes from more highly isolated transactions cannot be overwritten. |
adXactBrowse |
256 |
Indicates that from one transaction you can view uncommitted changes in other transactions. |
adXactReadUncommitted |
256 |
Same as adXactBrowse. |
adXactCursorStability |
4096 |
Indicates that from one transaction you can view changes in other transactions only after they have been committed. |
adXactReadCommitted |
4096 |
Same as adXactCursorStability. |
adXactRepeatableRead |
65536 |
Indicates that from one transaction you cannot see changes made in other transactions, but that requerying can retrieve new Recordset objects. |
adXactIsolated |
1048576 |
Indicates that transactions are conducted in isolation of other transactions. |
adXactSerializable |
1048576 |
Same as adXactIsolated. |
ADO/WFC equivalent
Package: com.ms.wfc.data
Constant |
|---|
AdoEnums.IsolationLevel.UNSPECIFIED |
AdoEnums.IsolationLevel.CHAOS |
AdoEnums.IsolationLevel.BROWSE |
AdoEnums.IsolationLevel.READUNCOMMITTED |
AdoEnums.IsolationLevel.CURSORSTABILITY |
AdoEnums.IsolationLevel.READCOMMITTED |
AdoEnums.IsolationLevel.REPEATABLEREAD |
AdoEnums.IsolationLevel.ISOLATED |
AdoEnums.IsolationLevel.SERIALIZABLE |