First of all, I would like to confirm my understanding of your issue. From
your description, I understand that you are having problem why trying to
add an index to Access 2002 table using ADOX. If there is any
misunderstanding, please feel free to let me know.
Based on my research, an Index object has a property named IndexNulls. Its
default value is adIndexNullsDisallow, which means null value is not
allowed on index fields. You can try to set it to adIndexNullsAllow before
adding the index to the table's index collection. And I think error will
not occur again.
For more information, please check the following link:
"This posting is provided "AS IS" with no warranties, and confers no