Can't get Delete query to run 1

[Rascelon]

I get an error message that says,
"Could not delete from specified tables."
when I run a simple delete query between 2 tables with NO dependencies. Here is the SQL.

DELETE Table1.*
FROM Table1, Table2
WHERE (((Table2.ID)=[Table1].[ID]));

The ID column is the primary key for each of the tables and both are AutoNumber (Random). I can view the records that should be deleted when I choose Datasheet View from the edit mode of the Delete query and that looks fine.

Not sure what I'm doing wrong. Any help?
Vince

 

[PHV]

And what about this ?
DELETE FROM Table1
WHERE ID In (SELECT ID FROM Table2)


Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[Rascelon]

Well... that was easier than I thought.
Thanks.
Vince