[thelist] Altering Design of AccessTable from Coldfusion

[rudy]

> I need to set the "Indexed" field of a table (as seen in the
> Design view when you open up a table in MS Access) to
> "Yes (No Duplicates)". You gotta be able to do this remotely
> by sql, right? I know this can be done in MySQL...

hi jon

sorry for the huge delay in replying

yes it's possible

No Duplicates implies unique, so your query would be

  create unique index yourIndex
       on YourTable ( yourColumn )

see

   HOWTO: Common DDL SQL for the
   Microsoft Access Database Engine (Q180841)
   http://support.microsoft.com/default.aspx?scid=kb;EN-US;q180841


rudy