Detailed description of the Recordset object method

Open Method
Recordset. Open Source, ActiveConnection, CursorType, LockType, Options
Source
The Recordset object can be connected to the Command object through the Source attribute. The Source parameter can be a Command object name, an SQL Command, a specified data table name, or a Stored Procedure. If this parameter is omitted, the system uses the Source attribute of the Recordset object.
ActiveConnection
The Recordset object can be connected to the Connection object through the ActiveConnection attribute. ActiveConnection can be a Connection object or a string containing the database Connection information (ConnectionString.
CursorType
The CursorType parameter of the Open method of The Recordset object indicates the type of cursor to start data, including adOpenForwardOnly, adOpenKeyset, adOpenDynamic, and adOpenStatic, which are described as follows:
Constant value description
AdOpenForwardOnly 0 default value, start a Forward-Only cursor (Forward Only)

AdOpenKeyset 1 starts a Keyset type cursor
AdOpenDynamic 2 starts a Dynamic type cursor
AdOpenStatic 3 starts a Static cursor
The preceding cursor types directly affect all attributes and methods of The Recordset object. The following lists the differences between them.
Recordset attribute adOpenForwardOnly adOpenKeyset adOpenDynamic adOpenStatic
AbsolutePage does not support read/write.
AbsolutePosition does not support read/write.
ActiveConnection can be read/written or read/write
BOF read-only
Bookmark does not support read/write.
CacheSize: readable/writable
CursorLocation: readable/writable
CursorType can be read/written or read/write
EditMode read-only
EOF read-only
The Filter can read and write, and can read and write.
LockType: readable/writable
MarshalOptions: readable/writable
MaxRecords
PageCount does not support read-only and read-only
PageSize: readable/writable
RecordCount does not support read-only and read-only
Source: readable/writable
State read-only
Status read-only
AddNew support
Support for CancelBatch
Supported CancelUpdate