"Could not delete from specified table" Error

When attempting to run the following query I got the "Could not delete from
specified table" Error. Any ideas why ?

DELETE Raw.*
FROM Raw INNER JOIN [raw data 2b deleted] ON (Raw.ATTR = [raw data 2b
deleted].MinOfATTR) AND (Raw.[Ticket Number] = [raw data 2b deleted].[Ticket
Number]);

Try something like this:

DELETE FROM Raw
WHERE EXISTS
(SELECT MinOfATTR
FROM [raw data 2b deleted]
WHERE (Raw.ATTR = [raw data 2b deleted].MinOfATTR)
AND (Raw.[Ticket Number] = [raw data 2b deleted].[Ticket Number]));

If subqueries are new, see:
How to Create and Use Subqueries
at:
http://support.microsoft.com/?id=209066

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Eric @ CMN, Evansville" wrote
in message
...
When attempting to run the following query I got the "Could not delete
from
specified table" Error. Any ideas why ?

DELETE Raw.*
FROM Raw INNER JOIN [raw data 2b deleted] ON (Raw.ATTR = [raw data 2b
deleted].MinOfATTR) AND (Raw.[Ticket Number] = [raw data 2b
deleted].[Ticket
Number]);