Changing field indexed property from code

C

Christopher

This question is about changing the indexed property of a linked tabl
field from code. I'm using Access 2000 with SP1.

What ultimately needs to happen is the index property to change fro
"Indexed (Duplicates OK)" to "Indexed (No Duplicates)". I also need t
change this property from code (I don't want the users going into th
back end).

I've tried making a new property and appending it to the field wit
tabledefs("tablename").fields("fieldName").properties.append

I've tried simply setting the .properties("Indexed") = "Indexed (N
Duplicates)"

I've tried doing both of those on the front and back ends. Nothin
seems to work. Is this just not possible to do? Any help would b
greatly appreciated. Thanks in advance.

Christophe
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Too Many Indexes Error 3
Need help modifying code 0
Indexed 'error' when changing index in table 1
Code to Change Doc Properties with Variables 0
Index field code displays, not index entries 1
Action Query (Append) didn't add records due to key violations. 6
Problem with Validation Error 13
how to append index key to the field in access 1

Top