Please explain me with examples which recordset cursors should I use and where (which condition). Like adOpenDynamic, adOpenForwardOnly, adOpenKeyset , adOpenStatic.

Please.

cursor types short view:

adOpenForwardOnly : fastest,lowest resources consumption
adOpenStatic : not updateable, prefeared for reports use, any change happened to the recordset is not visible
adOpenDynamic : most flexible (and slowest),any change happened to the recordset is visible, all cursor movements are allowed
adOpenKeyset : All types of movement are possible,any change happened to the recordset is visible, added rows are not visible, and also deleted rows are not accessible


Ahmed Ali
Software Developer