Delete Query

[Boon]

Hi,

When I use inner join, or just a normal join, sometimes Access didn't allow
me to delete the records. Sometimes it allows me to delete, sometiems it
doesn't.

Here is a SQL that it didn't allow me to delete.

DELETE Dealer_BG.*
FROM Dealer_BG INNER JOIN Dealer ON Dealer_BG.DLRCD = Dealer.DLRCD;


What did I do wrong? I would appreciate if you would explain why I cannot
delete it.

Thanks,
B

 

[vanderghast]

Try:


DELETE DISTINCTROW Dealer_BG.*
FROM Dealer_BG INNER JOIN Dealer
ON Dealer_BG.DLRCD = Dealer.DLRCD;



Vanderghast, Access MVP