Change index from No duplicates to duplicates allowed

R

ReidarT

How do I change Change index from No duplicates to duplicates allowed
in a table with DAO.
regards
reidarT
 
A

Allen Browne

I believe you have to delete the Index from the Indexes collection, and
create another one with the characteristics you want.
 

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

Code to temporarily change "no duplicates allowed" property 3
Compound Index 1
Access Auto Matching Duplicates? 0
Indexed 'error' when changing index in table 2
do not allow duplicates in subform 4
No Duplicates for Combo Field 2
you can not go to the specified record 1
Checking for duplicates 3

Top