Delete Query

[GlenLynam]

Afternoon All,

I have the following delete query...

DELETE Training.*, Personal.PersonID, Courses.CourseID
FROM Courses RIGHT JOIN (Training LEFT JOIN Personal ON Training.PersonID = Personal.PersonID) ON Courses.CourseID = Training.CourseID
WHERE (((Personal.PersonID) Is Null)) OR (((Courses.CourseID) Is Null));

Whenever i try and execute i get the error "Could not delete from specified tables." Any ideas on how to get my query to delete the records??

Thanks in advance

Glen

 

[mp9]

Surely something simple like this? (untested)

DELETE Training.* 
FROM Courses RIGHT JOIN (Training LEFT JOIN Personal ON Training.PersonID = Personal.PersonID) ON Courses.CourseID = Training.CourseID
WHERE (((Personal.PersonID) Is Null)) OR (((Courses.CourseID) Is Null));

 

[GlenLynam]

No sorry i get the same error message :-(

Thanks for the response any other ideas??

Thanks in advance

Glen

 

[GlenLynam]

It was the unique records setting was set to no for the properties of the query!!