"is not usable for indexed lookups due to unsupported collating sort order SortOrder"

When using some sort of software or you are working on some projects with Microsoft Access, this error may occurs because of the known limitation of Jackcess library.


Workaround: 

  • Change the "New database sort order" to "General" (or "General - Legacy").

Reference: https://stackoverflow.com/questions/27893630/unsupported-collating-sort-order-error-updating-access-database-from-java

https://stackoverflow.com/questions/31948096/how-to-change-sortorder-to-avoid-unsupported-collating-sort-order-error/31972659#31972659

Comments