RS.Open SQL, CONN, A, and B Interpretation A: AdopenForwardOnly (= 0) Read-only, and current data records can only move AdopenKeySet (= 1) read-only, current data records are free to move adomentynamic (= 2) Read and write, the current data record is free to move adOpenStatic (= 3) readable writing, the current data record is free to move, can see new record B: AdlockReadOnly (= 1) default lock type, record set is read-only, You cannot modify the recording of AdlockPESSIMISTIC (= 2) Pessimism, when modifying the record, the data provider will attempt to lock the record to ensure successful editing records. As long as the editing start, lock the record immediately. AdlockOptimistic (= 3) Optimistic lock until the record is locked when you submit an update record with an UPDATE method. Adlockbatchoptimistic (= 4) Batch optimism locks, allowing multiple records to be modified, only to lock the record only after calling the UpdateBatch method.
