Access databases that have Japanese characters are not sorted correctly in Access Services for SharePoint Server 2010

Consider the following scenario:

• You have a server that is running Microsoft SharePoint Server 2010 together with Access Services in Microsoft SharePoint Server 2010.
• The server language locale is Japanese.
• The language locale of a client computer is Japanese.
• You publish a Microsoft Access 2010 database from the client computer
• You open the published database, and you locate a table of Japanese characters.
• You select an ascending sort for a column that contains Japanese numbers.

In this scenario, the column is not sorted as expected in ascending order.

If you use Access 2010 to sort the database table on the same column, the table is sorted�correctly.

This issue occurs because Access Services on SharePoint 2010 supports backward compatibility with earlier versions of Access. Microsoft Office Access 2007 and earlier versions use an older style of sorting Japanese characters that does not correctly account for every Japanese number.