I have a linked SQL Server 2008 R2 table in my Access 2013 database. When I open the database, nothing opens (no forms, queries etc), and I am the only one in the database. I can run an update query and all fields will be updated as they should be, but if I open the linked table directly and try to type data into one of the rows, I get an error of "This record has been changed by another user"
What setting needs to be changed so I can edit data directly in the table?