Creating an Index for a table

[aziz rasul]

I have multiple append queries which transfers data to a single table. The table is initially created from a make-table query. How do I create an index using VBA after the append queries have been actioned?

 

[jfgambit]

Why are you making the table everytime? If you delete the data and then update the new information all indexing will remain as you had it originally. Is there a reason you have to recreate the table with each update?

 

[aziz rasul]

Because I could not stop someone from removing\changing the index accidentally. However I have found the solution:-

MyDB.Execute "CREATE INDEX NewIndexName ON TableName " & "([FieldName]);"