CodeDocu.com

Access Error: This record has been modified by another user since editing began.

 

Error:

This record has been modified by another user since editing began.

If you save the record, you will overwrite the other user's changes.

 

Copying your changes to the clipboard allows you to view the other user's changes and then paste changes if you wish

Save record

Copy to clipboard

Discard your own changes

 

Situation:

Microsoft Access database connected to a MySQL server database

Access Error: This record has been modified by another user since editing began.

 

The error 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.

Access Error: This record has been modified by another user since editing began.

 

Solution:

You have to change the ODBC driver in the ODBC data source connection.

To do this open the ODBC data sources administrator (enter ODBC in Cortana)

Then go to the section: System DSN

Then under System Data Sources, select the ODBC connection to the MySQL server database.

Then click Configure

Then the dialog appears: MySQL Connector / ODBC Source Configuration

Here under Details expand the configuration and then in the section: Cursors / Results

Enable:

Return matched rows instead of affected rows

Access Error: This record has been modified by another user since editing began.

 

After changing the ODBC connection you have to renew the table connection in MS Access.

To do this, select the bound table and switch to Table Link Manager.

Access Error: This record has been modified by another user since editing began.

 

In the Table Link Manager, select the connection and update with OK.

Access Error: This record has been modified by another user since editing began.

 

Check if the task is solved:

Thereafter, 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 may appear.

Access Error: This record has been modified by another user since editing began.

 

The same problem appears when accessing a SQL Server as database server with MS Access.

Here you have to insert an additional column of type timestamp Guid.


Software Entwicklung Stuttgart NĂ¼rtingen
Suche Projekte C#, WPF, Windows App,ASP.Net, vb.Net, WinForms, SQL Server, Access, Excel