Is "Selected collating sequence..." a serious error?
Posted on 2010-09-21
We're in the midst of migrating from XP/Office 2003 to Win7/Office 2007. We are not currently planning on converting any Access databases from 2003 to 2007. A handful of our users have received the "Selected collating sequence not supported by the operating system" error when opening or closing Access databases. Most likely these are 2007 databases opened in 2003, but I'm not entirely sure of that. I do believe this is only happening in Access 2003 though, since we have not made 2007 readily available.
I researched this error and frankly it doesn't sound that serious. The solution appears to be converting the databases or installing language packs, neither of which we really want to do.
So my question is, is this a serious error we need to resolve or can we simply explain what's happening and tell our users to ignore it?
The second question is, have I understood the suggested solution? It also sounds like the error will stop occurring if we change a setting in Access itself (Tools-Options-General-New Database Sort Order) but not being an Access guru I'm not entirely sure I'm reading it correctly. I can't determine if that is a setting that'll fix the problem for any database that's opened in the future or not.