Access User can't modify a record added to a linked SQL Server table
Posted on 2016-10-25
I have a linked table in Microsoft Access 2003 that's linked to a table in SQL Server 2012. The user specified in the connection has datareader permissions for the database in SQL Server, and for this one table has Grant permissions for Select, Update, and delete. I can modify existing records and add a new records using this linked table, but I can't modify or delete records that *I* added using the linked table. It gives me a message that the record was edited by another user when I try. How can I fix this?