Delete Query Doesnt work!

[Rafegh]

Hi
I have created a delete query. As I click datasheet view it shows the records matching the criterion that I have defined. But when I want to Run it, it doesn't run and views the message "Could not delete from specified tables." !
I have checked my document and it is not Read-only! How can I solve this problem?

[orange]

Post the SQL of the delete query involved.
Tell us more about your tables and relationships.
You may wish to research referential integrity

Good luck

[ranman256]

It could also be a query that can only delete via an IN sub query, where the matching codes are in the sub-query.

[Rafegh]

This is my sql code:
DELETE NoSamples.*, NoSamples.ProjectCode, NoSamples.SectionNo
FROM Temp INNER JOIN NoSamples ON (Temp.SectionNo = NoSamples.SectionNo) AND (Temp.ProjectCode = NoSamples.ProjectCode);

[June7]

No need to enumerate fields because DELETE removes entire record.

Maybe:

DELETE FROM NoSamples INNER JOIN ON Temp.SectionNo=NoSamples.SectionNo AND Temp.ProjectCode=NoSamples.ProjectCode;

Why do you need to delete records? Deleting records should be a rare event.