G
Guest
I have the following delete query that gives me the message "Could not delete
from the specified tables"
The table [Scores] does not have any relationships and I'm able to delete
records manually.
DELETE Scores.*, Scores.ID, Scores.Season, Scores.Visitor, Scores.[Visitor
Score], Scores.Home, Scores.[Home Score], Scores.Margin
FROM Scores INNER JOIN [Scores-Destinct] ON (Scores.Visitor =
[Scores-Destinct].Visitor) AND (Scores.[Visitor Score] =
[Scores-Destinct].[Visitor Score]) AND (Scores.Home = [Scores-Destinct].Home)
AND (Scores.[Home Score] = [Scores-Destinct].[Home Score]) AND (Scores.Margin
= [Scores-Destinct].Margin) AND (Scores.Season = [Scores-Destinct].Season)
WHERE (((Scores.ID)<>[Scores-Destinct].[MinOfID]) AND
((Scores.Season)=[Scores-Destinct].[Season]) AND
((Scores.Visitor)=[Scores-Destinct].[Visitor]) AND ((Scores.[Visitor
Score])=[Scores-Destinct].[Visitor Score]) AND
((Scores.Home)=[Scores-Destinct].[Home]) AND ((Scores.[Home
Score])=[Scores-Destinct].[Home Score]) AND
((Scores.Margin)=[Scores-Destinct].[Margin]));
from the specified tables"
The table [Scores] does not have any relationships and I'm able to delete
records manually.
DELETE Scores.*, Scores.ID, Scores.Season, Scores.Visitor, Scores.[Visitor
Score], Scores.Home, Scores.[Home Score], Scores.Margin
FROM Scores INNER JOIN [Scores-Destinct] ON (Scores.Visitor =
[Scores-Destinct].Visitor) AND (Scores.[Visitor Score] =
[Scores-Destinct].[Visitor Score]) AND (Scores.Home = [Scores-Destinct].Home)
AND (Scores.[Home Score] = [Scores-Destinct].[Home Score]) AND (Scores.Margin
= [Scores-Destinct].Margin) AND (Scores.Season = [Scores-Destinct].Season)
WHERE (((Scores.ID)<>[Scores-Destinct].[MinOfID]) AND
((Scores.Season)=[Scores-Destinct].[Season]) AND
((Scores.Visitor)=[Scores-Destinct].[Visitor]) AND ((Scores.[Visitor
Score])=[Scores-Destinct].[Visitor Score]) AND
((Scores.Home)=[Scores-Destinct].[Home]) AND ((Scores.[Home
Score])=[Scores-Destinct].[Home Score]) AND
((Scores.Margin)=[Scores-Destinct].[Margin]));