AnsweredAssumed Answered

Problem with 2 users editing the same record

Question asked by user8294 on Jul 10, 2009
Latest reply on Jul 13, 2009 by mrvodka


Problem with 2 users editing the same record


We have a script that performs some maintenance scripts in the background , it runs every 2 mins on a spare pc we have


Sometimes it tries to amend a record that someone is already working on via a different pc, at this point the script on the maintenance pc fails (we get this record is being modified by ****** with options send message or cancel)


I realise the is a protection facility on fm that guards database integrity, however i was wondering if there was anyway of being able to check if someone was already using that record before attempting to modify it? or any other solution that could possibly help?


Thanks in advance