Re: Error: "This record has been changed by another user..." when updating fields with same value

[Thomas Carr]

I am investigating updating a work-group access system to an SQL back-end.

I found the "timestamp" issue is not unique to MySQL. Access does not support a SQL "timestamp". Access uses an an arbitrary binary number, which is not a real timedate stamp, while an access "timestamp" will work with an MDB file, it will not work with an ODBC SQL system.

The work around and to keep the system backward compatible with a stand alone version, is to add a "time_stamp" field with a time-date format. Then you would have to "manually" update the "time_stamp" field each time the record is updated. Then "tell" the SQL system to use "time_stamp".

While you are at it, for audit purposes, since you have added a when field, "time_stamp", that a who and where fields be added, e.g. "user", "computer_name", "office", to records also.