Set regional settings in Access/VBA for current session
Posted on 2010-03-30
I have an Access 2003 application. Lots of people are using it from notebooks, desktop and thin clients. However, the users don't have access to their regional settings in the current corporate thin clients architecture. Sometimes, the IT people do things with the roaming profiles and for some reasons their regional settings are changed.
I would like to get my app shielded from these modifications.
I could format each field everywhere but that would be a significant time investment for a legacy app and I don't want to change the user regional settings from my application (bad idea)
So I'm asking...
Is there a way to change the regional settings for only the current access session?
I would like to use the default regional settings for english canada or french canada depending on a variable I control and not use the profile regional setting and not have to change it.
Is there a way to do this from Access 2003 / VBA ?