Delete Query Help

[Joker]

I am getting an error on a new Delete Query that I have never seen with any of my other queries... It seems simple, but I have not been able to make this one work.

I have a table and I want to delete all fields that have a specific ID
I have a Query that will return the one specific ID. I am using that query to select all only those records where they match.

If I select Datasheet View, It pulls the selected rows and displays them.
If I change the query Type from Delete to Select, it works fine.

Here is the error:
Could not delete from specified tables

The code:
DELETE T_DataToExport.*
FROM T_DataToExport, Q_Compile_Data
WHERE (((T_DataToExport.[ID])=[Q_Compile_Data].[ID]));

Any suggestions?

 

[Jon K]

DELETE *
FROM T_DataToExport
WHERE [ID] = (Select [ID] from [Q_Compile_Data]);
.

 

[Joker]

Jon,
It worked!!! Thanks, I appreciate the help.