Cannot modify record in Access Query
Posted on 2014-11-06
I have an Access 2010 FE that is linked to SQL Server 2005 for the BE.
I have a query that is simply ALL records from Table A. I can modify a record in this query and it will update without problem.
If I add criteria to the query, such as only records for customers in California, it will no longer allow me to update the data. I get a message that states "Write Conflict. The record has been changed by another user......etc etc".
Why is this happening. It did not used to happen when I programmed in earlier versions of Access.
Thanks for any help you can provide.