1、建个主键id或者加个自动编号列id,然后 delete from msg where id not in(select min(id)as id from msg group by tit)
其中tit为有重复的字段,在access中运行上述语句即可!