26.1.11.8. Access Returns Another user has modified the record that you have modified While Editing Records
With some programs, this error may occur: Another user
has modified the record that you have modified. In
most cases, this can be solved by doing one of the following
things:
Add a primary key for the table if one doesn't exist.
Add a timestamp column if one doesn't exist.
Only use double float fields. Some programs may fail when
they compare single floats.
If these strategies don't help, you should start by making a log
file from the ODBC manager (the log you get when requesting logs
from ODBCADMIN) and a MyODBC log to help you figure out why
things go wrong. For instructions, see
Section 26.1.9.7, “Getting an ODBC Trace File”.
