无法删除和更新访问链接表上的记录(cannot delete and update records on access linked table)

无法删除和更新访问链接表上的记录(cannot delete and update records on access linked table)

我有访问数据库名为road.mdb。 在road.mdb里面，我有一个链接的SQL表和 表名是学生。

我可以在MSAccess中使用查询设计插入记录

但我不能更新也不能删除

当运行删除查询时，错误是：无法从指定的表中删除

delete from student where studentid=303;

当我在下面运行更新查询时，错误是：操作必须使用可更新的查询

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

我可以完全访问sql数据库，我可以使用sql management studio运行查询。 使用MSaccess中的查询设计是否无法删除和更新？ 奇怪的是我可以使用MSaccess中的查询设计插入新记录

谢谢

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

最满意答案

我通过向SQL表添加主键并将表重新链接到ACCESS来解决这个问题

感谢大家...

I SOLVED this by adding primary key to the SQL table and re linked the table to ACCESS

Thanks everyone...