REMOVING DUPLICATES

[Hendrix10]

I'm using Access 97 and wanted to know if there is a way for me to
remove duplicates.


I can also use Access 00 and 03 but since other who don't have them
will be using the database I would prefer to use 97. But if I'm unable
to remove duplicates in 97 but can in 00 or 03 please let me know.

 

[mcnews]

I'm using Access 97 and wanted to know if there is a way for me to
remove duplicates.

I can also use Access 00 and 03 but since other who don't have them
will be using the database I would prefer to use 97. But if I'm unable
to remove duplicates in 97 but can in 00 or 03 please let me know.

duplicate records?

make a copy of the table (structure only).
create a primary key that combines the fields that you don't want
duplicated.
create an append query from old table to new table.
dupes will not be imported.

 

[Hendrix10]

I ran the append query and it gave me a result but it also gave me an
error message saying "Microsoft accees set 0 fields to Null due to a
type conversion failure, and it didn't add 40000 records to the table
due to key violations, 0 records due to loc violation, and 0 records
due to validation rule violations. How do I correct the key violation?

 

[mcnews]

I ran the append query and it gave me a result but it also gave me an
error message saying "Microsoft accees set 0 fields to Null due to a
type conversion failure, and it didn't add 40000 records to the table
due to key violations, 0 records due to loc violation, and 0 records
due to validation rule violations. How do I correct the key violation?

the key violation is what keeps the dupes out.

 

[John W. Vinson]

"Microsoft accees set 0 fields to Null due to a
type conversion failure, and it didn't add 40000 records to the table
due to key violations, 0 records due to loc violation, and 0 records
due to validation rule violations. How do I correct the key violation?

That suggests that there were 40000 duplicates that didn't get added to the
table (because you didn't WANT to add duplicates to the table). Did the unique
records get in?


John W. Vinson [MVP]