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