A Cursor Controls The Navigation Of Records In A Recordset

A cursor controls the navigation of records in a recordset and how the records will be updated 1.adOpenForwardOnly - this is the default cursor if no other is specified. This cursor allows only forward movement through a recordset 2. adOpenKeyset - this cursor supports forwards as well as backwards navigation. It also allows you to update a recordset and all changes will be reflected in other users recordsets. The cursor also supports bookmarking 3.adOpenDynamic - this cursor supports forward and backward navigation . Any changes made to data are immediately visible with no need to resynchronise the cursor with the database 4.adOpenStatic - this cursor uses a static copy of data from the database and therefore no changes to the data are visible and supports forward and backward

The locktype parameter specifies which type of locking should be used on the cursor when editing data in a recordset 1.adLockReadOnly - default type used when no locktype is specified 2.adLockPessimistic - forces the database to lock the entire record when editing first starts 3.adLockOptimistic - locks records only after you call the UPDATE method of the recordset object 4.adLockBatchOptimistic - allows batch

Db command type=AdCmdText adds the words given in th sql query to the command text