Sort order has changed

[rgbanse]

After converting from 97 to 2003, the sort order has changed. It appears that Access doesn't see any " ' " in names. It sorts by the character following the " ' ". Any thoughts.
Thx
RGB

 

[afryer]

Hi,

Do you have an example of items that are not being sorted?

Andrew

 

[rgbanse]

This is the sort order returned by Access 2003
OFFSHORE TEC
O'HARE HILTO
OIL SKIMMERS
OMEGA CASTIN
ONE POINT SO
O'NEAL STEEL
ONOX

This is the sort order returned by Access 97
OFFSHORE TEC
O'HARE HILTO
O'NEAL STEEL
OIL SKIMMERS
OMEGA CASTIN
ONE POINT SO
ONOX

thx
RGB

 

[BNPMike]

Can you show us the SQL?

 

[rgbanse]

just opening the table and using the sort button on the tool bar

 

[BNPMike]

You should really view your tables via queries, as a general rule. Just create a query copying all the table fields into the QBE grid and order your sort field. Does it still do that funny ordering?

 

[ZmrAbdulla]

Did you check what is set Tools > Options > General > New Database SortOrder?
You may find a clue there. Default is "General" in 97 and 2002
need to check in 2003

Zameer Abdulla
Visit Me

 

[rgbanse]

I found the problem - going from 16 to 32 bit
The latter ignores hyphens and apostrophe's during a sort
RGB