title: cannot delete and update records on access linked table
body: <p>I have access database called road.mdb.
  Inside road.mdb, I have a linked SQL table and<br>
  the table name is student. </p>
  
  <p>I can insert records using query design in MSAccess</p>
  
  <p>But I cannot update nor Delete</p>
  
  <p>when run delete query below, the error is: could not delete from specified table</p>
  
  <pre><code>delete from student where studentid=303;
  </code></pre>
  
  <p>and when I run update query below, the error is: Operation must use an updateable query</p>
  
  <pre><code>update student set Name='BOB' where studentid= 303;
  </code></pre>
  
  <p>I have full access to the sql database and I can run the query OK using sql management studio.
  Is it impossible to delete and update using query design inside MSaccess?? 
  The weird thing is I can insert new records using query design inside MSaccess</p>
  
  <p>thank you</p>