Deleting duplicates in an access database

[Caro]

I have an Access database which has a name and date as two fields within it. I want to make the two combined as a unique index but first I have to delete any duplicates - does anyone know a quick way to do this in VB?

[lenin]

Are there many duplicates?

If not you could put an identity field as a column into the table, and create a primary key based on this field. then delete manually.

If there are a lot, then there is a lot more work.

Let me know.

Lenin