VB macro for creating index

[RandWald]

Hi. Using Access 2003. What is the syntax for a VB command that would create an single-field index on a dbc database?

Thanks, Randy

 

[Jacob Mathai]

DoCmd.RunSQL "CREATE index act01 on actualsmaster(product_cd)"

For Unique index :

DoCmd.RunSQL "CREATE unique index act01 on actualsmaster(product_cd)"

 

[RandWald]

Thank you!

Jacob, thanks for your reply. All day, I have been surfing, the internet, f1 help and even guessing at what the command should be.

Randy