Write Conflict

[Lynn]

I am using Access 2000 and SQL 2000. I am creating an adp.

I have a form (frmMain) with a subform (frm_sbf). On the
subform the user can open another form (frm_popup) to
update additional information on a particular record.

The problem occurs when I close frm_popup and then try to
move to the next record on frmMain or move to the next
record in the subform itself.

I get a Write Conflict msgbox saying "This record has been
changed by another user since you started editing
it . . . " with 3 buttons: Save Record, Copy to Clipboard,
Drop Changes.

I have the unique table and resync command set on the
subform.

Thanks for the help!

 

[Lynn]

Here is the answer:

http://support.microsoft.com/default.aspx?kbid=304181