Create an Index in Access table 2

[MacroAlan]

I have a table that was created using the "Make Table" query.

Could I have added an index to one or more columns on the fly in VBA? Can I add the index afterwards?

I find vague references to the DDL but no code examples.


Alan

 

[PHV]

DoCmd.RunSQL "CREATE INDEX ...."

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[ByteMyzer]

Search Microsoft Office Access Help for the CREATE INDEX SQL statement.

 

[Remou]

You can also use TableDefs

[Code From MS Help] Set idxCountry = .CreateIndex("CountryIndex")
With idxCountry
.Fields.Append .CreateField("Country")
.Fields.Append .CreateField("LastName")
.Fields.Append .CreateField("FirstName")
End With
.Indexes.Append idxCountry[/code]