Knowledge Base

HOME: MySQL

MySQL database management system

---

4. Write Conflict when updating MySQL table in MS Access

Question:

When I modify a field in MS Access and try and save the record, it shows a "write conflict" error ("someone else has modified this record since you started editing it..."). I know this is not the case, nobody else is accessing this DB.


Answer:

The reason for this is that Access needs to have a field that is a timestamp in order for it to update fields. You should just create a field in your table that is type TIMESTAMP, and you will then be able to update the table.


Go to http://mysql.com/Manual/manual.html#ODBC for more information.

Updated: January 4, 2001

---