I have a replicated database that exists at two sites. The users enter data and periodically synchronize. There are chances of duplicate data entered by either user and I would like to drop one of the duplicate records after synchronizing. I would base this on selected fields (say 3 or 4 fields) which together would qualify the record as a duplicate and if possible add a condition like if the value of one record is +/- 300 of the other records and the other fields match then its a duplicate. Is there a way of doing this automatically in Access and if not, any suggestions of code that can be modified to do this are welcome.
Deleting duplicate records
- Thread starter jgnasser
- Start date
Similar threads
