Thanks for your thoughts Larry.

>I have also implemented pessimistic locking for some systems that the user needed/wanted something extra. They didn't want their users bogged down editing something that they weren't going to be able to save anyway. So an initial check is done to prevent this.

It is quite commmon for our users to step on each other's toes with regards to records, so I was thinking of using pessimistic buffering so that it will lock them out of the record when they try to amend it - they can spend up to about 1/2 hour populating memo fields, and get rather upset when the standard Record in Use message appears!

Cheres
Kev