Trouble with "... attempting to change the same data at the same t

[Roberto]

I have an Access 2007 Front End linked with a ODBC driver to a MySQL database
in a multiuser environment. I have a problem with a form that shows me the
values of a particular table.

Until a couple of days ago, when any users deleted a record, it works
perfectly. But since yesterday, when anyone tries to delete any record,
Access shows a dialog box with the following message:

“The Microsoft Office Access database engine stopped the process because you
and another user are attempting to change the same data at the same time.â€

It happens no matter if the record that I was trying to delete is a new
record that I am sure that is not been edited by any other person.

¿Can you help me?

 

[golfinray]

I know in my experience, I have to re-create the ODBC connection on occasion
and have even had to re-load the ODBC driver in Access and in sql before.
Sometimes it just loses its mind. Also, make sure all your permissions are
set properly. Hope this helps!

 

[Roberto]

That golfinray,


I allready try that and the problem is still happening.

I stop the MYSQL process in the server and rerun it, but it doesn´t work
either.

I rebuild a dump of the data base too, with the same result.


Do you have any other idea?