Update query...Write Conflict

  • Thread starter Lynn Pennington
  • Start date
L

Lynn Pennington

I have a form to allow user to change some information in
a Access table. The change will affect all the records in
the table so I created this Update Query to make the
change.

UPDATE tbl_DataSources SET tbl_DataSources.UID = [forms]!
[frm_DataSources]![txtUID], tbl_DataSources.PWD = [forms]!
[frm_DataSources]![txtPWD];

A "Write Conflict" dialog box appears with "Save
Record", "Copy to Clipboard" and "Drop Changes".

Please advise.
Lynn.
 
Top