I have access database called road.mdb.
Inside road.mdb, I have a linked SQL table and  

the table name is student. 

I can insert records using query design in MSAccess

But I cannot update nor Delete

when run delete query below, the error is: could not delete from specified table

```
delete from student where studentid=303;

```

and when I run update query below, the error is: Operation must use an updateable query

```
update student set Name='BOB' where studentid= 303;

```

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

thank you