Hi Guys,
   Trying to create a unique index but I get the message..
      "The alteration could not complete due to an error with the row 1667"

   How do I get to/identify the row 1667 please?

Regards & TIA,
Ian

Ian


>    Trying to create a unique index but I get the message..
>        "The alteration could not complete due to an error with the row 1667"
>
>    How do I get to/identify the row 1667 please?

Never seen anything like that so wild guessing time.You have duplicates in there so you can't have a unique index

Row 1667 will be the actual physical row in the table so a query

SELECT * FROM table WHERE __RowID = 1667

should get it

NB: its underscore underscore rowid

However, you want to identify all duplicates so something like

select _Forename,_Surname,count(*) from contacts group by _Surname having count(*) > 1

will do that for you

Roy

Ahhh.  Excellent.  Thanks Roy.
Regards,
Ian