Base Compartida!!

[Zeta]

En delphi usando F1 sobre las propiedades de un objeto podés solucionar mucho: En este caso sobre "LOCK TYPE" del ADO Table

ltUnspecified
A specific lock type has not been specified or determined.

ltReadOnly
Read-only; the current execution cannot modify data.

ltPessimistic
Pessimistic locks; locks instantiated on a record-by-record basis when edit mode is applied to a record.

ltOptimistic
Optimistic locks; locked are initiated on a record-by-record basis, but only when updates are applied and a record is being updated.

ltBatchOptimistic Optimistic batch updates; used for batch update mode rather than immediate update mode.

Me parece que mejor es implementar un procedimiento almacenado con lock type


Saludos