3 Replies Latest reply on Jul 13, 2009 6:31 AM by mrvodka

    Problem with 2 users editing the same record



      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