Write Conflict

doran_doran

Registered User.
Local time
Today, 14:30
Joined
Aug 15, 2002
Messages
349
Hi,

I am keep on getting Write Conflict whenever I check a check box called chkHCE. There are over 3000 records and it's happening for every records. I would understand if it's happening once in a while but it's happening for every records.

Please suggest. I attached the error print shot. The data souce is a qry but updatable query. The query has two tables tie together. I never had any problems. Can anyone share their idea Please ???

Thanks

Code behind the chkHCE

Private Sub chkHCE_Click()
If Me.chkHCE.Value = True Then
Me.HCEInitialPrepared.Enabled = True
Me.HCECompletionDate.Enabled = True
Me.HCEType.Enabled = True
Else
Me.HCEInitialPrepared.Enabled = False
Me.HCECompletionDate.Enabled = False
Me.HCEType.Enabled = False
End If

DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70
Me.CWSubform.Requery
Me.PlanWeight.Value = Me.PlanWeightCalc.Value

End Sub
 

Attachments

  • Write Conflict.jpg
    Write Conflict.jpg
    21.2 KB · Views: 192
Something you are doing in the code behind your form is conflicting with itself. This frequently is caused by using SQL to update a record that is bound to the open form and has been changed there.
 
I've also experienced a similar problem (the error is the same) with a complaint-tracking database.

How would you suggest to go around this and automatically save?
Additionally, when I choose the "Save Record" and then I go view the table that has the conflict.. Access pauses for a little and then produces an error.
To me it seems like there may be some sort of corruption error.

Has anyone had any solutions to this?
 

Users who are viewing this thread

Back
Top Bottom