error working with index collection

[villan60]

Hi

could someone tell me why the following code gives me the error "object does not support this funtion"

Set td = dbs.TableDefs("St12InvTemp&quot
For Each Idx In td.Indexes
td.Indexes.Delete Idx
Next Idx

I am trying to delete all the indexes from a table (obviously). Maybe at the same time you can tell me why access is creating indexes on fields when I do an import with a spec and ask for no indexes.

???

thanks
dax

 

[Aivars]

Hi, Dax!
You forgot add Name
td.Indexes.Delete idx.Name

Aivars

 

[villan60]

Thank you, you were absolutely correct.

Could you tell me now, why it does not delete all the indexes? After running that code I drop all the columns from the table and it gives me an error bcos there is still an index on one of the columns.

I also am bamboozled by the fact that it creates indexes for no good reason when I import this text file.

Thanks
dax