in Access (MDB) I have a table where I can Enter new data but if I edit or try to delete a table I get the error: "The Microsoft Access database engine stopped the process because you and another user are attempting to change the same data at the same time. (Error 3197)"
It is a linked table to SQL Server 2005.
There isn't anyone else on the server.
When I go to the Management Studio I can edit and delete. I've closed the management studio completely and updated the linked table, but it is only on that table.