在使用ODBC链接表连接到Sql Server之前，我遇到过类似的问题.解决方案是重新链接表并指定表的主键.如果Access不知道主键，它将无法执行插入或更新.

I've had a similar problem before when using ODBC linked tables to connect to an Sql Server. The solution was to relink the tables and specify the primary key to the table. If Access doesn't know the primary key it cannot perform inserts or updates.

我没有使用ADP的经验，但这可能是类似的事情，这里有一篇有关它的知识库文章 http://support.microsoft.com/?scid=kb%3Ben-us%3B235267&x=15&y=13

I haven't any experience with ADPs but it could be a similar thing, theres a knowledge base article about it here http://support.microsoft.com/?scid=kb%3Ben-us%3B235267&x=15&y=13