silme sorgusunun kodunu aşağıdaki kodla değiştirip dener misiniz?

delete * from tbl_tc where (tc_no=(SELECT  tbl_tc.tc_no

FROM tbl_tc

GROUP BY tbl_tc.tc_no

HAVING (((Count(tbl_tc.tc_no))>1))) and kimlik<>(SELECT First(tbl_tc.Kimlik) AS Kimlik

FROM tbl_tc

GROUP BY tbl_tc.tc_no

HAVING (((Count(tbl_tc.tc_no))>1))));