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?
Printable View
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?
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