Re: Removing Duplicates


"Jeff Howard" <jhoward@xxxxxxxxxxxx> wrote
What is the best way, using SQL, to remove duplicates
from an Access database?

Obvious answer: Prevent them from ever getting into the
tables by having proper unique keys.

Never having used Access, I suggest making a new table
with proper keys and copying the data from original to the
new table and letting the errors be left out. --JohnH
.

Relevant Pages