troubleshooting Question

SQL Backend "The data has been changed..." error

Avatar of reportingdude
reportingdude asked on
Microsoft AccessMicrosoft SQL Server
12 Comments2 Solutions1107 ViewsLast Modified:
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

Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 2 Answers and 12 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 12 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros