Write Conflict Error

[gselliott]

Is there anyway of stopping the Write Conflict message box appearing and automatically selecting 'Drop Changes' ? I am using a Multi User Helpdesk system and this message only rarely occurs when two users try to accept a job at exactly the same time.

It would be useful if this message could be replaced by my own msg box which says something like the user cannot make any changes and display an OK button.

Any help is much appreciated.

Thanks

 

[gselliott]

I have found the following code on another site that does stop the Write Confilct error message appaearing initially but once I click Yes or No the Write Confilct message appears again.

Private Sub Form_Error(DataErr As Integer, Response As Integer)

    If DataErr = 7787 Then
        If MsgBox("Yes - Save, No - Cancel", vbQuestion Or vbYesNo) = vbYes Then
            SendKeys "{TAB}~"
        Else
            SendKeys "{ESC}"
        End If
    End If
    
End Sub

Any ideas??