I'm going to use Pessimistic Record locking on my Multi-User database. My question is where can I place my custom MsgBox to pop up when a user tries to access a record that is already open. I' m using all unbound forms. Thanks DS
Hi, you can try following approach: Open recordset with this record and try to update it, if it fails - catch error number and then display appropriate message -- Best regards, ___________ Alex Dybenko (MVP) http://accessblog.net http://www.PointLtd.com "DS" wrote in message news:OrpQq289IHA.2332@TK2MSFTNGP03.phx.gbl... > I'm going to use Pessimistic Record locking on my Multi-User database. My > question is where can I place my custom MsgBox to pop up when a user tries > to access a record that is already open. I' m using all unbound forms. > Thanks > DS >
Thanks Alex I'll give that a try. DS
