Can Not Delete from specified tables
Posted on 2007-04-02
Access 2003 saving as Access 200 database
FROM TempTran02_canc LEFT JOIN TempTran ON (TempTran02_canc.Ptid = TempTran.Ptid) AND (TempTran02_canc.Datedata = TempTran.Datedata) AND (TempTran02_canc.Timeeff = TempTran.Timeeff);
Change to delete and it says can not delete from specified tables.
Where (tempTran.Ptid in (select Ptid from TempTran02_canc)) and (TempTran.Datedata in (select Datedata from TempTran02_canc)) AND (TempTran.Timeeff in (select Timeeff from TempTran 02_canc));
Reverse the order and it asks for TempTran02_canc.Ptid
I am almost there, but very tired. Looking for overnight help