I have an Access 2010 front end with a SQL server 2005 backend. I am trying to update from a form that is based on an updateable query based on two tables.
When I try to edit a record I get the standard message that the record has been edited by another user and the only options given are to drop the changes or copy them to clip board. It doesn't give me an option to override.
I am the only person accessing the record at that time since I'm working on a develop application.,