Specifies the xtent to which all outside transactions interfere with subsequent transactions of current connection.
Unit
MyAccess
Syntax
TMyIsolationLevel = (ilReadCommitted, ilReadUnCommitted, ilRepeatableRead, ilSerializable);
Values
| Value | Meaning |
|
ilReadCommitted |
Sets isolation level at which transaction cannot see changes made by outside transactions until they are committed. Only dirty reads (changes made by uncommitted transactions) are eliminated by this state of isolation level. The default value. |
|
ilReadUnCommitted |
The most unrestricted level of transaction isolation. All types of data access interferences are possible. Mainly used for browsing database and to receive instant data with prospective changes. |
|
ilRepeatableRead |
Prevents concurrent transactions from modifying data in current uncommitted transaction. This level eliminates dirty reads as well as nonrepeatable reads (repeatable reads of the same data in one transaction before and after outside transactions may have started and committed). |
|
ilSerializable |
The most restricted level of transaction isolation. Database server isolates data involved in current transaction by putting additional processing on range locks. Used to put aside all undesired effects observed in concurrent accesses to the same set of data, but may lead to a greater latency at times of congested database environment. |
