Troubleshoot sort (MDB)

Microsoft Office Access 2003

  • Specify a sort order if you haven't already done so.

    If you're working in a multiuser environment, someone else may have set a different sort order. Sort orders are saved with the query. You can change the sort order to the one you want.

  • If you've already specified a sort order, it may be set for the wrong field. Delete the sort you specified and specify a new sort order for the correct field.
  • If the sort order is set for the correct field, you may have selected Ascending when you really wanted Descending, or vice versa. Select the correct sort order.
  • If you have sort orders specified for more than one field, you may need to reorder the fields in the query design grid because Microsoft Access performs multiple sorts from left to right in the order the fields appear in the query design grid.
  • The field you specified the sort order for may be hidden. If you want to show the field you're using to sort records, make sure the Show check box is selected in the query design grid.
  • You can't set a sort order on a Hyperlink (or Memo) field in a data access page. However, you can sort on an expression by using the HyperlinkPart function.

ShowI can't find the language I want in the New database sort order box.

Some languages are included in the General sort order setting, although they used to be listed separately in the New Database Sort Order box (Tools menu, Options dialog box, General tab). The general sort order includes the following languages: Afrikaans, Albanian, Arabic, Basque, Bulgarian, Byelorussian, Catalan, Dutch, English, Faeroese, Farsi, German - Standard, Greek, Hebrew, Hindi, Indonesian, Italian, Malay, Portuguese, Russian, Serbian, Swahili, and Urdu.

ShowAccess isn't using the sort order I specified in a linked table.

If your database contains linked tables from a database that uses a different language sort order, Access uses the sort order of your database, not the database where the table is stored.

ShowI receive replication errors after I change the language sort order.

If you're synchronizing between replicas in an Access database, you might encounter synchronization conflicts if the databases don't have the same language sort orders.