How to fix the error of collating sequence not supported with the specified file format

When I use a ASP script to retrieve the data from a Access MDB file, I got an error: collating sequence not supported with the specified file format.
Actually, it happened when I move the site to a new server.
The solution was to go to the File tab in 2010, click the options link and set the sort order for new databases to ‘General – legacy’.

mdb-sorting-option


Then compact and repair the database file. Tools > Database Utilities > Compact and Repair Database
After above procedures, the error is gone.

  • Rich

    This did not fix my issue. When I open the Compact and Repair functionThe sort order is already on General – Legacy.

    I’m trying to compact a database written in an older version (suspect 2007) in 2013 and when I select save to the “Compact To…” database I get the error.

    • http://seo.g2soft.net David Yin

      If you can, maybe send the file to me, I can help you.