Add a New Indexed (duplicates allowed) Field

[RSfromCO]

I would like to programatically add a new field that is indexed (duplicates allowed) to an MS-Access database. What is the cleanest SQL statement(s) for achieving this?

So far... I just for adding the field...
ALTER TABLE MyTable ADD COLUMN MyField TEXT(16);

 

[Golom]

To index the field

CREATE UNIQUE INDEX myIndex
ON myTable (myField)

The Create Index statement is documented here

 

[RSfromCO]

Got it. I had to remove the UNIQUE parameter in order for it to allow duplicates in the indexed field.

Thanks.