Delete Old Duplicate Record

[Mike]

I have a Access Table with no Primary Key.This table is updated Daily with
new Records which might contains same values as already in the Table.
How do i delete Old Duplicates from the Table and keep the new One.
If i assign a Primary key i cannot input the new Value as the old one would
not allow to do so.

 

[Jeanette Cunningham]

Mike,
instead of deleting duplicates, have you considered not adding the duplicate
at all.
If two records really are duplicates, there is no point in trying to replace
the old one with the new one.
To prevent adding duplicate records, you can set a unique index over as many
fields as necessary.
To set a unique index, open the table in design view, on the toolbar select
indexes.
Type a name for the index like NoDupes in the name column, in the field name
column - select the first field name and in the lower pane set the Unique
property to Yes.
To add another field to this index, on the next row down, leave the name
column empty and select the field, repeat this for all the fields you need.
Save the table.
Do a test to see if the new index is working the way you want it to.
When you add the updated data, the duplicate data won't be added to the
table.

Jeanette Cunningham