At 11:34 AM 28/11/2008, you wrote:

>PS. I'm sure I don't need to supply this info but without the "with
>lock" on the edit-SQL and with .PessemistictLocking = False, both
>users can display the grid and put the same record into edit mode. Or
>have one user in edit and the other re-fresh their display query with
>no errors.

It seems you didn't understand that PessimisticLocking has to be set to True, not False. And only on the dataset that is editing the record.

>If both are in edit mode, the 2nd post and commit is what becomes the
>current data.

Of course. If PessimisticLocking is False, the normal concurrency rules of the transaction apply.

Helen