How do you Set a Unique Index from code 1

[xsnrg]

Follow up from thread705-884378

I have existing tables generated from an import code pulling SQL tables into my Access database. This import process looses the index definintions.

I need a second part of the code where I can set the index for the table. I've only found out how to do this within a Query or at the CreateDatabase process. But with the table already existing, how can I setup the primary key?

McLean Jones
buddycenters.org
"Believing is Seeing

 

[PHV]

Something like this ?
DoCmd.RunSQL "CREATE UNIQUE INDEX index_name" _
& " ON table_name (field1_name, field2_name)" _
& " WITH PRIMARY;"


Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[xsnrg]

Fantastic... that works great...

McLean Jones
buddycenters.org
"Believing is Seeing