MS Access - "This Record Has Been Changed By Another User Since You Started Editing It"
I know this has been asked many times, and I have tried many of the suggestions and solutions that worked for others, but I am not able to get this error to go away (please see attachment). 
This is an Access application that is really just a UI to a SQL Server database, and uses all linked tables to the SQL Server database. The user opens access and they go to a form that opens a "Search", where the user selects a bunch of criteria and clicks "Apply Filter". A list of records appears that meet their criteria. They click the record they want, and a form is opened that displays the details about this record. They then click an "Edit" button that opens another form that allows them to edit certain fields. When they make changes and hit save is when this error appears. The odd thing to me, this only occurs if the user selects the first record in the Search list, but it doesn't seem to happen with the others in the list.
What I have tried is the following:
- Added code on the "BeforeUpdate" and "Update Button Click" event to check "If Me.IsDirty = True Then Me.IsDirty = false" End If.
- Added a datetime column to the SQL database that gets updated with a trigger ON UPDATE
- Verified the database has no bit columns
- Changed the "Record Locks" property on the form to "Edit Records"
None of these items made a difference.
Any help on what might be causing this is appreciated.
2. Added a datetime column to the SQL database that gets updated with a trigger ON UPDATE
This could actually be the cause of your problem - Access and Sql Server modifying the same row at the same time is causing the write conflict you see.
I'm afraid you have misinterpreted the valid advice you found.
What you want is a ROWVERSION aka TIMESTAMP column in your Sql Server table. That helps Access figuring out if a row has changed and solve write conflicts. It is fully automatic and needs no trigger.
More details (Albert always provides lots of details :p ) here:
MS Access Write Conflict - SQL Server - Me = Dirty
If this doesn't help: check if you have any other triggers, and post your VBA code for filter / edit / save.
- How to make Colors Mixer in vba
- How to get HEX color value from cell color?
- VBA Macro doesn't work if the selection is only have 1 instance of the searched character
- Deleting a file in VBA
- Trying to late bind outlook to but getting type mismatch error after create object line
- Bitly API call using VBA Excel Macro
- excel vba projects not closing
- INDEX MATCH to also pull through notes
- Move formatted data in selection from Excel into Word tables
- Excel VBA function to remove letters at end of string
- Excel function to construct an array from values without VBA
- Alternative method to delete file with out having to add MS Scripting Runtime Reference
- How to implement joining muiltiple curves is Catia VBA?
- VBA: How to Loop IF Statement through a Cell and Chart Series
- Incorporating Checkbox to lines of code rather than Cell value
- How to write txt file at same file path but preventing window to update notepad display
- How do I remove a character from a column of data in Excel
- Loop to enter email address and attach applicable pdf
- Jump to an absolute page from the beginning of the document
- Excel VBA Selecting the files xxx_Before.log then xxx_After.log
- Run Time Error 1004 'Unable to get the PivotFields property of the PivotTable class' with Data Model Pivot Table
- How to find R_HOME with VBA Environ
- Append excel cell to end of a link and create a hyperlink
- How to Insert Double or Single Quotes
- How to get Reference plane from Sketch
- VBA create pivot with "data is added to the Data Model"
- Merge cells and add borders
- Need help about transposing rows to column
- how to check whether Scripting Runtime is available
- Optimize VBA code on lookup without using Vlookup