borrrar registros repetidos

[[Caral]]

Hola
En access los corchetes [ ] funcionan en otras BD no.
Tambien pasa lo mismo con el HAVING y el DISTINCTROW.
Tal vez:

Código SQL [-]
DELETE FROM base WHERE base.id IN (SELECT DISTINCT base.id FROM base WHERE (((base.id) In (SELECT id  FROM base As Tmp Where Count(*)>1 GROUP BY [id] ))) ORDER BY base.id)

Saludos