sort order: '97 vs XP

[Mark]

On Access 97, the sort order is:

O'N
Oa

On Access XP, it's like the telephone directory:

Oa
O'N

.... is there a sorting order option somewhere in Access 97 that can make
this consistent with XP? (Tools/Options/General/New Database Sort Order has
"General" selected).

Thank you.
Mark

 

[Van T. Dinh]

Sorry, no options that you can change.

This behaviour changed by design in JET 4.0 (which is used by A2K - A2K3).

For more info., see the Microsoft Knowledge Base article:

http://support.microsoft.com/?id=236952