Having developed the basis of a new database for a charity and having demonstrated it to the charity staff I have now been asked to get it installed on their premises. For this I will install MySQL Community Server, and set up the usual ODBC links for each user PC to connect the Access front end to the tables held in the server.
I have done this on my own PC to set it all up in advance and have immediately run into a problem - queries that now update tables in the server from tables in the front end fail with lock violations. I have checked that the tables in the server all have the same specifications as their originals in the front end and have failed to find the cause.
Please ask for any more information needed