Deleting from join queries

[ciarra41]

Is there something wrong with deleting join queries in Access? At first it ran just fine but now I’m getting that annoying message: Could not delete from the specified tables. What happen?

DELETE table1.IDtable1, table2.*
FROM table2 INNER JOIN table1 ON table2.IDtable2 = table1.IDtable1;

 

[AlexCuse]

Try adding DELETE DISTINCTROW, this happens to me very often.

However, You cannot delete a single column from your table.

This is how I would delete everything from table 2 though.

DELETE table2.*
FROM table2 INNER JOIN table1 ON table2.IDtable2 = table1.IDtable1;

Hope it helps,

Alex

Ignorance of certain subjects is a great part of wisdom