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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

sqlite-odbc write conflict 2
Write conflict 3
trying to minimize Write Conflicts in a multi-user database 62
Write Conflict 8
Display bug in Word: tables disappearing on copy and paste of text with bullet points into table 2
Check/Uncheck All, write conflict 4
Updated fields query 5
Cannot edit data in a Query 6

Top