CLEAR ME for ever... open table for updating

[sal21]

I need a clearifaction to open table for updating...

Wath is the correct parameter ?

adOpenDynamic, adLockOptimistic
or
adOpenKeyset, adLockPessimistic, adCmdTable
or
...

and i need to set a cursor for updating?

please...!!!!!

note:
i use vba for excel and adojet

[HansV]

There is not a single correct answer. It depends on the situation.

See ADO Open Method and also:

Open Method (ADO Recordset)
CursorTypeEnum
LockTypeEnum
CommandTypeEnum

[sal21]

There is not a single correct answer. It depends on the situation.

See ADO Open Method and also:

Open Method (ADO Recordset)
CursorTypeEnum
LockTypeEnum
CommandTypeEnum

WOW! Tks.