I am using the below code to try to edit a linked SQL server table from an Access front end.
It returns the following error:
Error 3197: The Microsoft Jet database engine stopped the process because you and another user are attempting to change the same data at the same time.
If I try to edit the record directly in the table, I receive the error in the screenshot.
I am able to create records ok.
There are no other users in this database at any time.
With CurrentDb.OpenRecordset("SELECT * FROM dbo_TimeSheets WHERE TransactionID=" & Me.TransactionID, dbOpenDynaset, dbSeeChanges)
!order = Me.order
!EmployeeID = Me.EmployeeID
!Labor_Date = Me.Labor_Date
!No_Of_Hours = Me.No_Of_Hours