I want to be able to lock a record in an Access database to keep two people from working on a specific record simultaneously (pessimistic lock).
It looks like sql_setPos is what I want but I don't quite understand how to implement it.
It looks like I need to configure sqlTools to return a multiple line dataset.
Then after I retrieve the record I want, use sql_setPos to lock the record until I'm done.
Am I on the right track?
It looks like sql_setPos is what I want but I don't quite understand how to implement it.
It looks like I need to configure sqlTools to return a multiple line dataset.
Then after I retrieve the record I want, use sql_setPos to lock the record until I'm done.
Am I on the right track?
Comment