create an index with vba code

[jpeddie]

how do I create an index on an access table with vba code?

 

[Dirk Goldgar]

how do I create an index on an access table with vba code?

You can do with DAO objects, by using the TableDef.CreateIndex method;
see the online help of Index Object. Or you can build and execute a SQL
CREATE INDEX statement.

 

[Tim Ferguson]

how do I create an index on an access table with vba code?

This comes straight from the Help files:

strSQL = "CREATE INDEX NewIndex " & _
"ON Employees " & _
"(HomePhone, Extension);"

db.Execute strSQL, dbFailOnError

Hope that helps


Tim F