We help IT Professionals succeed at work.

MS Access 2003  - Update/Delete fails with Write conflict/clipboard error

Last Modified: 2010-03-19

I'm afraid this problem has been mentioned more than once on the experts-exchange before.
I tried all suggestions for solutions that I could find, but I can't seem to fix the problem:
I just upgrade my MS SQL from MSDE to MSSQL 2005, and a frontend created in Ms Access 2003, connecting to the database using ODBC connection.
I am using SBS 2003 for the Server, and WinXp for the workstations (10 PC)

 I can added new records with no problem to the table via the form, but if I try to update or delete existing records, I get the error:
Write conflict:
This record has been changed by another user since you started editing it. If you save the record, you will overwrite the changes the other user made.
Copying the changes to the clipboard will let you look at the values the other user entered, and then paste your changes back in if you decide to make changes.

This problem just happened after using MS SQL 2005, and only a few computers have this problem.
I checked all the MS Access references, the version for the OS + MS Office. All are the same between the workstation that have a problem and the one that working.

Any assistance greatly appreciated!

Cheers and thanks,

Watch Question

This is usually because two "things" have written to the current record. For instance, if the user makes a change and your code makes a change, Access can treat it as two different users and so make you choose who gets to commit the change. This can also happen if something on the SQL server writes to the record (identity field, trigger, stored procedure etc) while the user is editing the data.

for that matter, you may be supplying an autonumber field and SQL is supplying an ident for the same field.

have a look around and see what you can find.


Hi Slamhound,

Thanks a lot for your reply.
About the autonumber, I have an autonumber field for the ID.
I copied the frontend from one PC to another PC. And from 10 workstations only 3 got that problem (can add a new record  but can not edit). also basically just one user accessing the database. That 3 computers/ws always have a problem when editing the record but the rest no problem at all. So I just wondering is it because of the software issue?
If the problem with the MS Access form or MS SQL script why only happened on that 3 particular computers/ws only.


If you put a different user at thoes computers, does this issue still happen? I'm wondering if it's the way thoes 3 particular users are entering the data.

Also, make sure thoes 3 computers have no firewall, virus checker or any other security device that may be affecting things. (you can turn these back on once you work out wich is causing the issue) Also, make sure that these 3 computers have the latest patches from Microsoft and the same versions of all other software. If there is other software running in the background, try disabling that too.


Yup,  I tried to login as a different user and still got that problem.
And all the software have the latest update and same version. I turned off the firewall but still cant fix the problem.
Have you got the latest MDAC version and the latest .Net framework? If their MDAC is old the pcs may be comminucating with the 2005 like it's a 2000 SQL server.


Well, I checked all the computers MDAC before, and all have a same version. all used 2.7. I tried ones using 2.8 but looks not working as well.
Unlock this solution and get a sample of our free trial.
(No credit card required)
That makes sense. A bit field can't have Null in it...It's either True of False. My guess is that Access was finding the Null bit field and a) didn't know what to do with it or b) tried setting it to a valid value.

Closed, 500 points refunded.
EE Moderator
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.


Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.