Access tells me the record was changed by another user when I'm the only accessing the record
Posted on 2011-03-18
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.,