Hi,

   I have a simple form based on a table that is linked to a SQL server back end.

   The form is to a junction table where users are assigned assets. I use a look up combo box to select a serial number, then I use the tables combo boxes to change the user name etc. I have a button to close and reopen the same form to make sure the update has gone through.

   This has been working fine for a few months, but now, most times when I click the update button (close, reopen) I get a Write Conflict dialog box that states that the record has been changed by another user since I opened it. I know no other user is connected to the database. Normally there is an option to Save Record, but it is greyed out.

   Any help on this?

Thanks,


mmcdonal

__________________
mmcdonal

Look it up at: http://wrox.books24x7.com

Hi!
1.
If you have trigger or procedure to update table it can be cause of Write Conflict Msg.
2.Some times this code helps.
Private Sub cmdSave_Click()
On Error GoTo Err_cmdSave_Click
        DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70
bfurman

I am not sure where that code should go. This is the code from the Button's On Click event:

Private Sub btnUpdate_Click()
On Error GoTo Err_btnUpdate_Click

    Dim stDocName As String
    Dim stLinkCriteria As String

    stDocName = "frmDetails"
    DoCmd.Close
    DoCmd.OpenForm stDocName, , , stLinkCriteria

Exit_btnUpdate_Click:
    Exit Sub

Err_btnUpdate_Click:
    MsgBox Err.Description
    Resume Exit_btnUpdate_Click

End Sub

   It is pretty crude. It just opens the form and closes it.

   If I don't click this button and just go to a new serial number, I get the same message. It is when I try to move off the record in any way that this happens. It didn't used to happen. It just started.


mmcdonal

Check for trigger or procedure to update any field in table you make last time.
For what do you need to close and open form, isn’t it simpler just refresh form after updating field. (me.refresh)

The code should go before this line: DoCmd.Close

DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70
DoCmd.Close