Delete query problem

[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

 

[John Spencer]

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
..

 

[Keith Wilby]

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

Sounds like it's not an updatable query.

Keith.