Specify the default language sort order for a database

Set this option to specify the alphabetical sort order that Microsoft Access uses when you create a new database.

1. On the Tools menu, click Options.
   
   
2. Click the General tab.
   
   
3. In the New Database Sort Order box, click the language that you want to use.

Notes  

• To reset the sort order for an existing database to the language that you selected on the General tab, compact that database.
  
  
• Some languages that were listed separately in the New Database Sort Order list in previous versions of Microsoft Access are now included in the General sort order setting.
  
  
• If your database contains linked tables from a database that uses a different language sort order, Microsoft Access uses the sort order of your database, not the database where the table is stored.
  
  
• If you're synchronizing between replicas in a Microsoft Access database and a Microsoft SQL Server database, you might encounter synchronization conflicts if the databases don't have the same language sort orders.