Posts

Showing posts from December, 2021

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

Image
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