Delete duplicates

[Deborah Mowry]

Apparently to eliminate duplicate records I need to do an append query to a
new table structure containing the desired fields for the new table and a
key field.
I copied the Contacts table with structure only. In the new table I made the
ID a key field which was not done in the first place. Then I did an append
query from the original table to the new table and structure.
This was supposed to get rid of the duplicates because of the new key field.

However, NOTHING is in the table. I get "...1102 records due to key
violations,...69054 due to validation rule violations. Do you want to run
the query anyway..." and I say Yes. It still does nothing and there are no
validation rules to begin with.
Any ideas?

 

[Michel Walsh]

Hi,



For the key violation, that is either the duplicated values, either NULLs.
If you wish to keep the NULL, make the field an index, not a primary key,
but still not allowing duplicated values.

The validation rules are something else, those are not typical. Have you
copy the structure of another table then modified it to add the no
duplicated values constraint? It is also possible you get a data type
mismatch. Anyway, that is not supposed to occur, but you have to supply more
details... and probably find the reason doing so... A simple trick is
trying to add one record, by hand, with existing values. The same error
should occur then too! and it may be easier to debug that way.


Hoping it may help,
Vanderghast, Access MVP