How do I display & change table indexes within a class module?

[Guest]

Access allows a designer to open a table and view/change indexes in Design
View. I want to allow any user to view/add indexes of any table using a
Class Module I design. It's a relatively straight-forward process to list
the properties of an Index and IndexFields within a TableDef object. But how
best should I show the index information? Can I use the object that Access
makes available in Design View? I can't seem to find it using the object
browser. If not I guess I will have to build a copy and populate the text
fields with index information.

 

[Guest]

Dan,

Why would you want to let users create indexes? They could create unneeded
indexes that would just bloat the database and slow down inserts and changes.
They could even create a unique or primary key index that would break the
database.