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’.

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

Share on Facebook

Tweet

Related posts:

Error regarding collating sequence for Access DOS Format and Unix Format How to fix error Age of Empires 3 in Windows 10 7z command to compress file with date as file name PHP – Parse error: syntax error, unexpected end of file Fix the error: Parameter 1 to W3_Plugin_TotalCache::ob_callback() expected to be a reference, What can go wrong when including another file into your php file