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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Linked SQL Tables don't report Cascading Updates and Deletes 2
Record-Locking remains open after closing 0
Access Lock Violations 0
Linked Table Cant Delete Record 2
Delete query 2
MS Query 4
Make Table Query Only Runs After Edit 1
Access Front - SQL Back - File Locking 6

Back
Top