Access Error: This record has been modified by another user since
This record has been modified by another user since editing began.
If you save the record, you will overwrite the other user's changes.
your changes to the clipboard allows you to view the other user's changes and
then paste changes if you wish
your own changes
Access database connected to a MySQL server database
message also appears as here:
The Microsoft Access Database Engine stopped the process because you and
another user are trying to change the same data at the same time.
have to change the ODBC driver in the ODBC data source connection.
this open the ODBC data sources administrator (enter ODBC in Cortana)
to the section: System DSN
under System Data Sources, select the ODBC connection to the MySQL server
the dialog appears: MySQL Connector / ODBC Source Configuration
under Details expand the configuration and then in the section: Cursors / Results
Return matched rows instead of
changing the ODBC connection you have to renew the table connection in MS
this, select the bound table and switch to Table Link Manager.
Table Link Manager, select the connection and update with OK.
if the task is solved:
when directly opening a table to the MySQL database when writing to a cell,
changing to the next row and then changing the previous cell again, no error
same problem appears when accessing a SQL Server as database server with MS
you have to insert an additional column of type timestamp Guid.