CursorLocation and LockType

Can someone explain to me when to use what cursorlocation and locktype for opening recordset?

adOpenForwardOnly - Static copy of records. Doesn't reflect changes done by other users. Can only move forward through the recordset.

adOpenStatic - Also a static copy of records. However all types of movement are supported.

DAO adOpenDynamic - Non-static copy of records. Shows changes done by other users. All types of movement supported.

DAO adOpenKeyset - Records are updateable. However additions and deletions don't appear.

Thanks but I know all of that already. That is cursor type.

I am looking to understand cursorlocation(clientside, serverside) and locktype.

adLockReadOnly (Default) Read-only — users cannot alter the data.
adLockPessimistic Pessimistic locking, record by record — the provider does what is necessary to ensure successful editing of the records, usually by locking records at the data source immediately upon editing.
adLockOptimistic Optimistic locking, record by record — the provider uses optimistic locking, locking records only when the Update method is called.
adLockBatchOptimistic Optimistic batch updates — required for batch update mode as opposed to immediate update mode.


cursor location:
http://msdn.microsoft.com/library/en...idecursors.asp

Thanks Mendhak,

You and JoshT has helped me quite a bit on ASP questions in the past.

By any chance, do you know anything about this one?

http://www.vbforums.com/showthread.php?threadid=232076

Thanks again,

Hawk

Quote:

---

Originally posted by Hawk
Thanks Mendhak,

You and JoshT has helped me quite a bit on ASP questions in the past.

By any chance, do you know anything about this one?

http://www.vbforums.com/showthread.php?threadid=232076

Thanks again,

Hawk

---

You're welcome, and click here. :)