Delete Query error

[Jerry]

I'm getting the message "Could not delete from specified tables" when
running the
following query:

DELETE ADBT.id_number, ADBT.ids_type_code, ADBT.other_id, ADBT.to_advance,
ADBT.*
FROM ADBT INNER JOIN BadSSNsInADBT ON (ADBT.ids_type_code =
BadSSNsInADBT.ids_type_code) AND (ADBT.id_number = BadSSNsInADBT.id_number)
AND (ADBT.other_id = BadSSNsInADBT.other_id);

I can view the results but not perform the delete operation.

Thanks,

Jerry

 

[Michel Walsh]

Hi,


Add the word DISTINCTROW right after DELETE... when you delete over a join.




Hoping it may help,
Vanderghast, Access MVP

 

[GRayL]

In the design view (not SQLview) of the query, right
click on the table area and select properties.
Set "Unique records" to Yes. Re-run your query and your
delete should work. Somewhere in the KB there is an
answer to this.

-----Original Message-----
I'm getting the message "Could not delete from specified tables" when
running the
following query:

DELETE ADBT.id_number, ADBT.ids_type_code,

ADBT.other_id, ADBT.to_advance,