adOpenStatic = Read only, MoveNext, MovePrevious, Bookmark
adOpenForwardOnly = allow updates, MoveNext only
adOpenKeyset = allow updates, Bookmark
LockType
adLockBatchOptimistic = Indicates optimistic batch updates. Required
for batch update mode.
adLockOptimistic = Indicates optimistic locking, record by record. The
provider uses optimistic locking, locking records only when you call
the Update method.
adLockPessimistic = Indicates pessimistic locking, record by record.
adLockReadOnly = Indicates read-only records. You cannot alter the data.
--- In ms_access@yahoogroups.com, "tam_yehia" <[EMAIL PROTECTED]> wrote:
>
> Hi all, i'd like to ask a question: what is the difference between
> Access cursor type values (adopendynamic, adopenstatic, ...) and also
> what's the difference between all lock type values (optimistic,
> readonly, ...etc). and when to use each one.
>
> thanks
>
SPONSORED LINKS
Microsoft access database | Database development software | Database management software |
Database software | Inventory database software | Membership database software |
YAHOO! GROUPS LINKS
- Visit your group "ms_access" on the web.
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.