Changing Access Table Properties from Word

[Bo Hansson]

Following attemt fails - how to do it?

Dim dbs As Database, tdf As TableDef, idx As DAO.Index



Set dbs = OpenDatabase("DataBaseName")



Set tdf = dbs.TableDefs("TableName")



Set idx = tdf.Indexes("FieldName")




idx.Unique = False



"Cannot set the property of an objekt that is part of a collection"



????



Bo Hansson

 

[Jezebel]

The Unique property of a DAO Index is read only once the Index has been
appended to the Indexes collection. You need to delete the index and
recreate it.

 

[Bo Hansson]

OK, thanks a lot!

Bo Hansson

The Unique property of a DAO Index is read only once the Index has been
appended to the Indexes collection. You need to delete the index and
recreate it.