Problem deleting records

[John]

Hi

When I try below query;

DELETE Table1.*
FROM Table2 INNER JOIN Table1 ON Table2.[ID] = Table1.[ID];

I get the error 'Could not delete form specified tables'. What am I doing
wrong?

Thanks

Regards

 

[Allen Browne]

Try a subquery instead of a join.

Example:
http://allenbrowne.com/subquery-01.html#DeleteUnmatched