I have an application with a table that has buffering set to 3 (Optimistic record lock). When a user is entering a new record I issue a "Begin Transaction" When he/she presses on the SAVE button I issue a "End Transaction", if he/she presses on the CANCEL button I issue a "Rollback".

Until the user clicks on the SAVE/CANCEL button, it seems that the entire table is locked... No other user can do a thing... Move between records, update, insert or delete...

Any ideas?

Thanks in advance,

Mike