>Help please
>How can I differeces the pessimistic and optimistic in buffering modes?
>can give some example?
>
>thanks in advance

Kelvin

Essentially: Pessimistic means the record is locked all the time the user has (editing) access to it, until the record pointer is moved on or TableUpdate() or TableRevert() are issued. So, it one user has a record, keeps it for a long time while he eidts it, then other users have no access to it during this time.

Optimistic means the record is locked ONLY when the TableUpdate() is issued, so there's far less chance of the above contention.

On top of this there is Row and Table buffering for both cases. Table buffering locks all records in the table, during either an "optimistic" or "pessimistic" length of time.

See help on BufferMode and BufferModeOverride properties

HTH

Terry