[RESOLVED] [2005] Exist or not

[GaryMazzone]

I'm using Access 2003 but should be the same all the way back to Access 95.

Open the table in design mode.
Select the Index tool in the Toobar
In the index name line add a new Name What every you want.
In the field name column Select the First Field Name,
Continue adding fieldnames down in a list.
Set the Unique Property to True


When done this will create the unique index you want.