There is only me that uses the db, I can only think I must have unset it accidentally when doing some tweeks. Now the above code is in place to check I don't accidentally change it again.
Hi,
I am trying to find a way to check if an existing Field in a Table, Indexed Property value = Yes (No Duplicates), before running some imports via VBA.
I don't know what happened but noticed the field index Property had changed from Yes (No Duplicates) to Yes (Duplicates OK) and it caused...