I have a master table of machine tool layouts with enquiry number and tool layout numbers as main fields (not using any primary key).
I have a query generated separately from other criteria in the project, listing the enquiry numbers and tool layout numbers that I want to delete from the master table.
I have made delete query showing the master table as "Where" and built in the criteria for the 2 main fields referring to the other query.
In datasheet view it is correctly showing the selected records.
However, when I run the query to delete, it gives a message "Could not delete from specified tables".
I also tried using the field joins from the query to the table but same thing happens.
Any ideas on how to make it work?
I could of course use recordset in VBA and delete the selected records using a loop but would like to avoid that.
Thanks in advance