One issue I’ve found using Microsoft Access as a front end to MySQL is that when running an update query I often got an error saying the record was not updated due to a lock violation. It turns out if the data Access is updating is the same as the existing values then it gives […]