ADO Properties on MSDN
Open method on MSDN
recordset.Open Source, ActiveConnection, CursorType, LockType, Options
Cursor Location (MSDN, DevGuru) Constant Value Description adUseClient 3 Use client-side cursor supplied by the local cursor library adUseClientBatch 3 Obsolete, same as adUseClient adUseNone 1 Obsolete, no cursor service adUseServer 2 Default, use the cursor supplied by provider or database
Cursor Type (MSDN, DevGuru) Constant Value Description adOpenDynamic 2 A dynamic cursor with both forward and backward scrolling where additions, deletions, insertions, and updates made by other users are visible adOpenForwardOnly 0 Default, a forward scrolling only, static cursor where changes made by other users are not visible adOpenKeyset 1 A keyset cursor allows you to see dynamic changes to a specific group of records but you cannot see new records added by other users adOpenStatic 3 A static cursor allowing forward and backward scrolling of a fixed, unchangeable set of records adOpenUnspecified -1 Cursor type not specified
Lock Type (MSDN, DevGuru) Constant Value Description adLockBatchOptimistic 4 Multiple users can modify the data and the changes are cached until BatchUpdate is called adLockOptimistic 3 Multiple users can modify the data which is not locked until Update is called adLockPessimistic 2 The provider locks each record before and after you edit, and prevents other users from modifying the data adLockReadOnly 1 Read-only data adLockUnspecified -1 Lock type unknown
ENTERING SUB DEUX
Demandé Obtenu Location Type Lock Location Type Lock Count Time 1 -1 -1 1 0 1 -1 0 s 1 -1 0 1 0 1 -1 0 s 1 -1 1 1 0 1 -1 0 s 1 -1 2 1 0 2 -1 0 s 1 -1 3 1 0 3 -1 0 s 1 -1 4 1 0 4 -1 0 s 1 0 -1 1 0 1 -1 0 s 1 0 0 1 0 1 -1 0 s 1 0 1 1 0 1 -1 0 s 1 0 2 1 0 2 -1 0 s 1 0 3 1 0 3 -1 0 s 1 0 4 1 0 4 -1 0 s 1 1 -1 1 1 1 -1 6 s 1 1 0 1 1 1 -1 5 s 1 1 1 1 1 1 -1 4 s 1 1 2 1 1 2 -1 9 s 1 1 3 1 1 3 -1 6 s 1 1 4 1 1 4 -1 6 s 1 2 -1 1 2 1 -1 0 s 1 2 0 1 2 1 -1 0 s 1 2 1 1 2 1 -1 0 s 1 2 2 1 2 2 -1 0 s 1 2 3 1 2 3 -1 0 s 1 2 4 1 2 4 -1 0 s 1 3 -1 1 3 1 -1 6 s 1 3 0 1 3 1 -1 6 s 1 3 1 1 3 1 -1 5 s 1 3 2 1 1 2 -1 9 s 1 3 3 1 1 3 -1 7 s 1 3 4 1 1 4 -1 6 s 2 -1 -1 2 0 1 -1 0 s 2 -1 0 2 0 1 -1 0 s 2 -1 1 2 0 1 -1 0 s 2 -1 2 2 0 2 -1 0 s 2 -1 3 2 0 3 -1 0 s 2 -1 4 2 0 4 -1 0 s 2 0 -1 2 0 1 -1 0 s 2 0 0 2 0 1 -1 0 s 2 0 1 2 0 1 -1 0 s 2 0 2 2 0 2 -1 0 s 2 0 3 2 0 3 -1 0 s 2 0 4 2 0 4 -1 0 s 2 1 -1 2 1 1 1321480 14 s 2 1 0 2 1 1 1321480 15 s 2 1 1 2 1 1 1321480 13 s 2 1 2 2 1 2 1321480 21 s 2 1 3 2 1 3 1321480 18 s 2 1 4 2 1 4 1321480 25 s 2 2 -1 2 2 1 -1 0 s 2 2 0 2 2 1 -1 0 s 2 2 1 2 2 1 -1 0 s 2 2 2 2 2 2 -1 0 s 2 2 3 2 2 3 -1 0 s 2 2 4 2 2 4 -1 0 s 2 3 -1 2 3 1 1321480 12 s 2 3 0 2 3 1 1321480 11 s 2 3 1 2 3 1 1321480 12 s 2 3 2 2 1 2 1321480 19 s 2 3 3 2 1 3 1321480 18 s 2 3 4 2 1 4 1321480 17 s 3 -1 -1 3 3 1 1321480 7 s 3 -1 0 3 3 1 1321480 7 s 3 -1 1 3 3 1 1321480 7 s 3 -1 2 3 3 4 1321480 7 s 3 -1 3 3 3 3 1321480 7 s 3 -1 4 3 3 4 1321480 7 s 3 0 -1 3 3 1 1321480 7 s 3 0 0 3 3 1 1321480 7 s 3 0 1 3 3 1 1321480 6 s 3 0 2 3 3 4 1321480 7 s 3 0 3 3 3 3 1321480 7 s 3 0 4 3 3 4 1321480 7 s 3 1 -1 3 3 1 1321480 7 s 3 1 0 3 3 1 1321480 7 s 3 1 1 3 3 1 1321480 7 s 3 1 2 3 3 4 1321480 7 s 3 1 3 3 3 3 1321480 7 s 3 1 4 3 3 4 1321480 7 s 3 2 -1 3 3 1 1321480 7 s 3 2 0 3 3 1 1321480 7 s 3 2 1 3 3 1 1321480 7 s 3 2 2 3 3 4 1321480 7 s 3 2 3 3 3 3 1321480 7 s 3 2 4 3 3 4 1321480 7 s 3 3 -1 3 3 1 1321480 7 s 3 3 0 3 3 1 1321480 7 s 3 3 1 3 3 1 1321480 7 s 3 3 2 3 3 4 1321480 6 s 3 3 3 3 3 3 1321480 7 s 3 3 4 3 3 4 1321480 7 s
478 s