Delete Query Fail

[Hile_Troy]

I am trying to run a simple delete query and for some reason, can't get it to work. Every time I run it I get Error 3086 - Could not delete from specified tables. Below is the SQL code for the query:-

DELETE DISTINCTROW Processes.*, [Risk Rating of Processes].*, Processes.[Process Number]
FROM (DeleteProcessTemp INNER JOIN Processes ON DeleteProcessTemp.ProcessNumber = Processes.[Process Number]) INNER JOIN [Risk Rating of Processes] ON Processes.[Process Number] = [Risk Rating of Processes].[Process Number]
WHERE (((Processes.[Process Number])=[DeleteProcessTemp]![ProcessNumber]));

I have already built Add and Amend queries in the same database that work fine, but this one has me stumped. Much thanks for any and all assistance offered.

 

[jackd]

You can only delete from one table at a time.
Here is info on DELETE
http://www.techonthenet.com/sql/delete.php

 

[Hile_Troy]

Thanks, will try just deleting from the 'parent' table, cascade delete should take care of the other table. Will let you know if it works/ doesn't work.

 

[Hile_Troy]

Thanks jackd, worked a treat, just got to suppress alerts now, but I know how to do that...

 

[boblarson]

Thanks jackd, worked a treat, just got to suppress alerts now, but I know how to do that...

Actually, you may not know the best way. The best way is NOT to use DoCmd.SetWarnings but instead to use

CurrentDb.Execute "QueryName Or Query SQL Here", dbFailOnError

 

[Hile_Troy]

Thanks boblarson, DoCmd.SetWarning didn't work anyway, but it runs without a hitch even if I don't suppress alerts. Happy days