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"));
you need to have several separated deletes
check solutions from the article:
I get the error message "Could not delete from the specified tables"
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.
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.