Delete Query in Access 2010 Doesn't Work

Access 2010.
When I try to run the query below it gives me the Could Not Delete from Specified Tables error.
I used the exact same query on different data (same table names and structure) and it runs fine - I created this in Access 2003 last year - tried running it in 2010 and it runs.

DELETE [Filter 3 Make Table].*, [Filter 3 Make Table].ResType
FROM [Lessees after Filter 3 for Delete Query] INNER JOIN [Filter 3 Make Table] ON ([Lessees after Filter 3 for Delete Query].Unit = [Filter 3 Make Table].Unit) AND ([Lessees after Filter 3 for Delete Query].MP = [Filter 3 Make Table].MP)
WHERE ((([Filter 3 Make Table].ResType)<>"LESS"));

Thanks Experts!
Who is Participating?
Eugene ZConnect With a Mentor Commented:
you need to have several separated deletes


check solutions from the article:

I get the error message "Could not delete from the specified tables"
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.