Execute a Delete Query on MS SQL linked tables

  • Thread starter Thread starter nora !!!
  • Start date Start date
N

nora !!!

I have an Access Database in which i have linked tables (
from a Sql Server database).
I can modify and delete data from Access.
But When i want execute a Delete Query or Update Query on
Access, i have an error message :
Unable to delete 1 row because of lock Violation ???
I'm the only user connected so do i lock myself ?
How can i resolve this ?
 
Do you have permission to delete or update stuff onto the table? You might have to talk to the SQL admin to give you enough permission to run those kinds of query onto the SQL tables.
 
Back
Top