Hi all
I'm gettting a Write Conflict error from Access when closing a form. Basically I wrote a function which populates a Yes/No field when any field in the record is updated, using the code:
Public Function ModifyCC()
Dim MySQL As String
Dim MyDB As Database
Set MyDB = CurrentDb
MySQL = "UPDATE tblChangeControlLog SET chkModified = True WHERE intcclogid = " & Forms!frmChangeRequestForm.intCCLogID & ""
MyDB.Execute MySQL
MyDB.Close
End Function
However when I change something, sometimes I get the error to say that the record has been changed by another user therfore I will overwrite their changes if I continue. However the database is currently on my machine used only by myself. I don't know why I'm getting the error, or indeed why it seems to be intermittent for no apparent reason. Any help would be greatly appreciated.
Matt
I'm gettting a Write Conflict error from Access when closing a form. Basically I wrote a function which populates a Yes/No field when any field in the record is updated, using the code:
Public Function ModifyCC()
Dim MySQL As String
Dim MyDB As Database
Set MyDB = CurrentDb
MySQL = "UPDATE tblChangeControlLog SET chkModified = True WHERE intcclogid = " & Forms!frmChangeRequestForm.intCCLogID & ""
MyDB.Execute MySQL
MyDB.Close
End Function
However when I change something, sometimes I get the error to say that the record has been changed by another user therfore I will overwrite their changes if I continue. However the database is currently on my machine used only by myself. I don't know why I'm getting the error, or indeed why it seems to be intermittent for no apparent reason. Any help would be greatly appreciated.
Matt
