P
Phil Smith
I find myself using workarounds for this way too often. A little advice
would be appreciated.
I have Three tables. I want to delete all entries from TableA where
TableB.Deleteme=yes and TableC.SignedOff = "yes". I get:
Cannot delete from specified table.
It seems like anytime I have more then one table involved, I can't delete.
I remove all of the other tables, and I can successfully delete.
Example query which fails. First version is exactly as teh Design View
builds it, the second is an editied version to remove waht appears to be
superfluous references. Both look the same in the Design Grid neither
run without generating the above error.
DELETE item_prebook_linkWRITEABLE.*,
item_prebook_linkWRITEABLE.prebook_id, prebook.name, item.active
FROM prebook INNER JOIN (item INNER JOIN item_prebook_linkWRITEABLE ON
item.item_id = item_prebook_linkWRITEABLE.item_id) ON prebook.prebook_id
= item_prebook_linkWRITEABLE.prebook_id
WHERE (((item_prebook_linkWRITEABLE.prebook_id)=150) AND
((prebook.name)="Special") AND ((item.active)="N"));
DELETE item_prebook_linkWRITEABLE.*
FROM prebook INNER JOIN (item INNER JOIN item_prebook_linkWRITEABLE ON
item.item_id = item_prebook_linkWRITEABLE.item_id) ON prebook.prebook_id
= item_prebook_linkWRITEABLE.prebook_id
WHERE (((item_prebook_linkWRITEABLE.prebook_id)=150) AND
((prebook.name)="Special") AND ((item.active)="N"));
would be appreciated.
I have Three tables. I want to delete all entries from TableA where
TableB.Deleteme=yes and TableC.SignedOff = "yes". I get:
Cannot delete from specified table.
It seems like anytime I have more then one table involved, I can't delete.
I remove all of the other tables, and I can successfully delete.
Example query which fails. First version is exactly as teh Design View
builds it, the second is an editied version to remove waht appears to be
superfluous references. Both look the same in the Design Grid neither
run without generating the above error.
DELETE item_prebook_linkWRITEABLE.*,
item_prebook_linkWRITEABLE.prebook_id, prebook.name, item.active
FROM prebook INNER JOIN (item INNER JOIN item_prebook_linkWRITEABLE ON
item.item_id = item_prebook_linkWRITEABLE.item_id) ON prebook.prebook_id
= item_prebook_linkWRITEABLE.prebook_id
WHERE (((item_prebook_linkWRITEABLE.prebook_id)=150) AND
((prebook.name)="Special") AND ((item.active)="N"));
DELETE item_prebook_linkWRITEABLE.*
FROM prebook INNER JOIN (item INNER JOIN item_prebook_linkWRITEABLE ON
item.item_id = item_prebook_linkWRITEABLE.item_id) ON prebook.prebook_id
= item_prebook_linkWRITEABLE.prebook_id
WHERE (((item_prebook_linkWRITEABLE.prebook_id)=150) AND
((prebook.name)="Special") AND ((item.active)="N"));