Description
Governs the case-sensitivity of the index.
KeyCaseSensitive = true 'Marsh' and 'marsh' are different keys
KeyCaseSensitive = false 'Marsh' and 'marsh' are duplicate keys
N.B. Also affects the various search and filter methods.
This property should not be changed frequently on an open file since, when it is changed, the index has to be re-checked for duplicates. In particular, when the index goes from being case-sensitive to case-insensitive there is the possibility of keys becoming non-unique. Any such keys are automatically purged from the database (which may not be what you want to do!). The purge operation also invokes the Pack method.