Delete query problem

  • Thread starter Thread starter Ticotion
  • Start date Start date
T

Ticotion

Hi

I'm trying to do a simple query delete from a tabel, but recieves the
following massage. Could not delete from specified tables. My SQL looks like
this:

DELETE [1_Grunddata].*
FROM 3_3part INNER JOIN 1_Grunddata ON [3_3part].Material =
[1_Grunddata].Material;

Could anyone help?

Ticotion
 
Try
DELETE DISTINCTROW [1_Grunddata].*
FROM 3_3part INNER JOIN 1_Grunddata
ON [3_3part].Material = [1_Grunddata].Material;

If that fails then try

DELETE [1_Grunddata].*
FROM 1_Grunddata
WHERE [1_Grunddata].Material IN (SELECT Material FROM [3_3part])


--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..
 
Ticotion said:
Hi

I'm trying to do a simple query delete from a tabel, but recieves the
following massage. Could not delete from specified tables. My SQL looks
like
this:

DELETE [1_Grunddata].*
FROM 3_3part INNER JOIN 1_Grunddata ON [3_3part].Material =
[1_Grunddata].Material;

Could anyone help?

Ticotion
Click to expand...

Sounds like it's not an updatable query.

Keith.
 
Back
Top