SQL Backend "The data has been changed..." error
Posted on 2013-01-03
I recently migrated a database backend from Access to SQL Server utilizing the SQL Server Migration Assistant (SSMA).
The migration did add the SSMA_TimeStamp field to my migrated tables.
I am getting the "The data has been changed...Re-edit the record" message box when switching between subforms and then trying to update a field or press a button linked to a macro.
I have researched this issue a little bit and it was suggested the timestamp field would help alleviate the error, but it doesn't seem to be working in my case.
The front end database does have numerous update queries linked to buttons and record changes, so not sure if that is somehow an issue.
My question is twofold;
1 - is there anything I need to do in terms of query structure to properly utilize the SSMA_Timestamp fields that were created during the migration to SQL?
2 - Is there something else I should try to fix the error? Users are able to edit after clicking ok on the error message, but this is obviously far less than ideal