How to change index programmatically

Chlaris · Jul 14, 2009

Dear all,

I have existing primary key index which consists of field A + field B.
Now I want to modify the index which consists of field A + field B + field
C.
How to change it programmatically ?
Thanks.

Chlaris

Alex Dybenko · Jul 14, 2009

Hi,
you have to delete existing key and then create a new one. You can do this
either using DAO (see CreateIndex Method), or DDL (see ALTER TABLE
Statement)

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com