Access 中执行Delete操作出现问题（急）

[rosea]

语法很简单，执行时出现"无法从指定的表中删除”的错误提示，这是怎么回事？

小弟急用，请大侠指点

[xirumin]

有主键吗

[rosea]

有主键

[rosea]

语法：
DELETE dbo_profile.*
FROM duplicateprofile,dbo_profile
where (duplicateprofile.i_customer_id = dbo_profile.i_customer_id)

[zsgzsgzsg]

DELETE dbo_profile.*
FROM duplicateprofile INNER JOIN dbo_profile ON duplicateprofile.i_customer_id = dbo_profile.i_customer_id

[zhengjialon]

因为你的这个查询是个不可新的查询。

[changechange]

DELETE dbo_profile.*
FROM duplicateprofile INNER JOIN dbo_profile ON duplicateprofile.i_customer_id = dbo_profile.i_customer_id

[rosea]

还是不行呀
一：DELETE dbo_profile.*
FROM dbo_profile, duplicateprofile
WHERE ((dbo_profile.i_customer_id=duplicateprofile.i_customer_id) and (dbo_profile.i_question_id= duplicateprofile.i_question_id) and (dbo_profile.i_survey_id=duplicateprofile.i_survey_id ));
二：DELETE dbo_profile.*
FROM duplicateprofile INNER JOIN dbo_profile ON (duplicateprofile.i_customer_id = dbo_profile.i_customer_id) AND (duplicateprofile.i_question_id = dbo_profile.i_question_id) AND (duplicateprofile.i_survey_id = dbo_profile.i_survey_id);
一和二两种方法都不行
三：
DELETE dbo_profile.*
FROM dbo_profile
WHERE (i_customer_id in (select i_customer_id from duplicateprofile)) and (i_question_id in (select i_question_id from duplicateprofile)) and (i_survey_id in (select i_survey_id from duplicateprofile));
第三种方法虽然可以，但执行起来太慢

使用第一和第二种方法时，出现的错误提示“无法从指定的数据表中删除”到底是什么意思？