Lock record demo

[Sawlmgsj]

Using the Lock demo.

Two instances of program - edit a record in first.
Try to edit same record in second. Get hour glass and wait.
Only released after saving first instance.

How do I return a message to user of second instance.
Where do I place 'try except' clause?

Have tried it in MSQuery1BeforeEdit, but has no effect - just sits there waiting. Do I need to set anything else?

Thanks,
Steve.

[Antaeus]

You should change value of the LOCK_TIMEOUT server variable to get an exception when the lock attempt failed.
More information about this variable you will find by this link.