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

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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.
 
Back
Top