Randy Birch has some good code to show how to determine Locale-related
information at
http://vbnet.mvps.org/code/locale/localecountry.htm
(Obligatory warning: Randy's site is aimed at VB programmers. Because of
difference in the Form model in VB and Access, some of his examples don't
work as-is in Access: changes need to be made. Looking at this particular
example, though, I think it'll port to Access without any problem).
As to changing the default language, I'd strongly suggest reconsidering this
requirement. User Settings are picked for a reason. As a developer, you have
no business changing settings that the user has chosen. Write your code to
be able to work regardless what the user settings are. I know I'd quickly
scrap any application that wouldn't let me keep my settings. Remember, these
settings are universal to the computer, and yours won't be the only
application running.
