Duplicate Queries

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello Everyone --

In Access 2000, is there an easy way of deleting the dupes after getting the results of a Duplicate Query? It seems like there should be.................... Thanks!
 
Gino,

If your table does not have an autonumber PK that is linked to another
table, you can do the following trick:
Make a copy of your table, delete all the records and make all fields part
of the primary key. Then make an append query to send all the records of the
original to the copy; the duplicates will be rejected. Either delete all
records from the original table and copy back the (cleaned-up) records from
the copy, or delete the original and rename the copy to the original's name.
Caution: if your original table has a relationship with one or more others,
make sure you remove it before you do either, and restore it when you're
done.
In any case, always make a backup copy before you try anything!

HTH,
Nikos

GinoC said:
Hello Everyone --

In Access 2000, is there an easy way of deleting the dupes after getting
Click to expand...
the results of a Duplicate Query? It seems like there should
be.................... Thanks!
 
Thanks, Nikos! That just might work for me...

----- Nikos Yannacopoulos wrote: -----

Gino,

If your table does not have an autonumber PK that is linked to another
table, you can do the following trick:
Make a copy of your table, delete all the records and make all fields part
of the primary key. Then make an append query to send all the records of the
original to the copy; the duplicates will be rejected. Either delete all
records from the original table and copy back the (cleaned-up) records from
the copy, or delete the original and rename the copy to the original's name.
Caution: if your original table has a relationship with one or more others,
make sure you remove it before you do either, and restore it when you're
done.
In any case, always make a backup copy before you try anything!

HTH,
Nikos

GinoC said:
Hello Everyone --
Click to expand...
the results of a Duplicate Query? It seems like there should
be.................... Thanks!
 
Back
Top