Delete Query error

  • Thread starter Thread starter Jerry
  • Start date Start date
J

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
 
Hi,


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




Hoping it may help,
Vanderghast, Access MVP
 
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,
Click to expand...
ADBT.other_id, ADBT.to_advance,
 
Back
Top