HELP!!! it's way to late to be doing this

[Pudge27]

I using the following SQL statement to try to delete records driven by a field in another table. This works using a select or make table query does this practice not work with delete queries:

DELETE [MF Back_Up Data].*, [MF Back_Up Data].FileMark
FROM [MF Back_Up Data], Administration
WHERE ((([MF Back_Up Data].FileMark)=[administration]![Filemark]));

Could not delete from specified tables. (Error 3086)
is the error I get..

 

[mdmilner]

A late answer, but...

Any chance you're attempting to delete records from tables in a relationship and you're about to break it?