Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

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

View products that this article applies to.


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.

↑ Back to the top


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.

↑ Back to the top

Keywords: KB983041, kbdatabase, kbsurveynew, kbpubtypekc, kbexpertiseinter, kbprb

↑ Back to the top

Article Info
Article ID : 983041
Revision : 2
Created on : 3/21/2011
Published on : 3/21/2011
Exists online : False
Views : 510