Solved

Delete Query in Access 2010 Doesn't Work

Posted on 2012-03-15
1
435 Views
Last Modified: 2012-04-11
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!
0
Comment
Question by:Nero83
1 Comment
 
LVL 42

Accepted Solution

by:
EugeneZ earned 500 total points
ID: 37727451
you need to have several separated deletes

more:

check solutions from the article:

I get the error message "Could not delete from the specified tables"
http://office.microsoft.com/en-us/access-help/i-get-the-error-message-could-not-delete-from-the-specified-tables-HA010096316.aspx
0

Featured Post

Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Article by: Leon
Software Metering within our group of companies has always been an afterthought until auditing of software and licensing became a pain point. Orchestrator and SCCM metering gave us the answer and it was an exciting process.
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.
Viewers will learn how the fundamental information of how to create a table.

776 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question