ADO.Recordset Open method:
prototype:
Recordset.open Source, ActiveConnection, Cursortype, LockType, Options
Source is generally a SELECT statement for query, used to return a data set,
ActiveConnection: Due to the calculation of a valid Connection object variable name, optional. It is used to connect the possible Connectio object.
Cursortype CursortyPEENUM value, cursor type.
There are four types:
AdopenForwardOnly opens a near-forward type cursor (default), the most efficient.
AdopenKeyset
AdoPendynamic
AdoPenStatic
LockType, specify the lock type of the Recordset, with the following types:
AdlockReadonly: Read only (default)
AdlockPESSIMISTIC: Conservative lock
Adlockoptimistic: open lock
AdlockBatchOptimistic: Open batch update.
