Access 2003 - query and table names don't sort correctly

[Guest]

I have a sequence of queries named "1-", 1a-", "1b-", etc. In Access 2000 on
a windows 2000 OS, the queries sort alphabetically in that order, but in
Access 2003 on an XP Pro OS they don't. Instead they sort in this order:
"1a-", "1b-", "1-". I have them sorted this way as a convenience and a
reminder which order I need to run some manual queries. Does anybody know
how to set the sort in Access 2003 to how it was in 2000?

Thanks

 

[Douglas J Steele]

Don't think there's anything you can do about it.

See http://support.microsoft.com/?id=236952 although that doesn't explain
why it would be different between Access 2000 and 2003.