Delete Query Won't Run

[TKnight]

Hi,

I'm trying to delete some records out of a table. I have a query that acts as a filter and is linked to two fields of the table that I want to delete from. I have put the * field from the table in the query and set the "Unique Values" property to "Yes". Access tells me "You cannot delete from the specified table".

The filter query is not an aggregate one, and if I remove it and simply have the table I want to delete from (i.e. delete all records) it will let me. I have done this loads of times before but this time it won't budge.

Any ideas?

Thanks, Tom

 

[ScottGem]

You can't do a Delete query with Unique Values set to Yes, since Access won't know which of the dups to delete. Also, to supply criteria to filter the delete query its better to use an IN clause as criteria, rather than a Join to another table.