MS Access delete Query
I have  query in MS Access that produces a correct records result, but Access refuses to run the Query as a delete query?  
Can any one help me rewrite this query to run in access.

    Delete Table_A.*
    FROM (SELECT Table_A.Main_RecID, Table_A.Fld_Unique_ID, Table_A.Actiontaken FROM Table_A 
    WHERE Table_A.Actiontaken="MainRecord deleted")  AS Tmp_B 
    LEFT JOIN Table_A ON Tmp_B.Main_RecID=Table_A.Main_Recid
    WHERE (((Table_A.Actiontaken)<>"MainRecord deleted"));

If the "Delete" is replaced by a select or I ask for a datasheet view the Query produces what I would expect.  Which is a list of the records in the table that have the same Main_RecID as records with Actiontaken field = "MainRecord deleted" but do not have their Actiontaken field equal to "MainRecord deleted".  

Access responds with the message "Could not delete from specified tables."  
MS Access delete Query
===

I have  query in MS Access that produces a correct records result, but Access refuses to run the Query as a delete query?  
Can any one help me rewrite this query to run in access.

    Delete Table_A.*
    FROM (SELECT Table_A.Main_RecID, Table_A.Fld_Unique_ID, Table_A.Actiontaken FROM Table_A 
    WHERE Table_A.Actiontaken="MainRecord deleted")  AS Tmp_B 
    LEFT JOIN Table_A ON Tmp_B.Main_RecID=Table_A.Main_Recid
    WHERE (((Table_A.Actiontaken)<>"MainRecord deleted"));

If the "Delete" is replaced by a select or I ask for a datasheet view the Query produces what I would expect.  Which is a list of the records in the table that have the same Main_RecID as records with Actiontaken field = "MainRecord deleted" but do not have their Actiontaken field equal to "MainRecord deleted".  

Access responds with the message "Could not delete from specified tables."  