You can open a recordset with four types of cursors. The cursor determines what you can do with a record set. The cursor also determines what other users can change to a record set. Different types and restrictions on the cursor are listed below:
Adopenfowardonly. Use the forward cursor, you can only move forward in the recordset.
AdopenKeyset. With the KeySet cursor, you can move forward or backward in the recordset. If another user deletes or changes a record, the recordset will reflect this change. However, if another user adds a new record, the new record will not appear in the recordset.
AdoPendynamic. With dynamic cursors, you can move forward or backward in the recordset. Any variation of the records caused by other users will be reflected in the recordset.
AdoPenStatic. With a static cursor, you can move forward or backward in the recordset. However, static cursors do not reflect the change in records caused by other users.
-------------------------------------------------- -------------
AdlockReadonly. Specify that you cannot modify the record in the record set.
AdlockPESSIMISTIC. Specifies to lock it immediately when editing a record.
Adlockoptimstic. Specifies that the record is locked only when the UPDATE method is called.
Adlockbatchoptimstic. Specifies that records can only be updated in a quotation.
