BeginTrans Method Connection Object Recordset Object PROPERTY:  Connection::IsolationLevel IsolationLevelEnum = connectionobject.IsolationLevel connectionobject.IsolationLevel = IsolationLevelEnum The IsolationLevel property is the level of transaction isolation for a Connection object. The purpose of the isolation level is to define how other transactions can interact with your transactions, and vice versa. For example, can you see changes in other transactions before or after they are committed? This property only goes into effect after you make a BeginTrans method call.   This property sets or returns an IsolationLevelEnum value. If the requested level is not available, the provider may be able to set the IsolationLevel to the next higher level.   IsolationLevelEnum Constants   Constant Value Description adXactUnspecified -1 Cannot use the provided isolation level and cannot determine the isolation level adXactChaos 16 Cannot overwrite higher level transactions adXactBrowse 256 Allows you to view uncommitted changes in other transactions adXactReadUncommitted 256 Same as adXactBrowse adXactCursorStability 4096 Allows you to view changes in other transactions only after they are committed adXactReadCommitted 4096 Same as adXactCursorStability adXactRepeatableRead 65536 Cannot see changes made in other transactions, but allows you to requery adXactIsolated 1048576 Your transactions are completely isolated from all other transactions adXactSerializable 1048576 Same as adXactIsolated   Code (VBScript): Set objConnection = Server.CreateObject("ADODB.Connection") objConnection.Mode = adModeRead objRecordset.IsolationLevel = adXactIsolated ... objConnection.Open strConnect Copyright 1999-2001 by Infinite Software Solutions, Inc. All rights reserved. Trademark Information