Hello Everyone,
I have quiet delicate problem with regional settings... hope somebody knows the answer.
I have MS Access database and there is a table linked from SharePoint.
I am using UK regional settings and that SharePoint is set with German regional settings.
When I open the DB and open that table numbers in it are 100 times greater then it should be.
The reason for this is because "." (dot) in UK is used for digital grouping (separate thousands) and "." (dot) in Germany is used for decimal places...
So - German 10.11 (Ten point eleven) is 1011 (One thousand and eleven) in UK.
I have tried starting MS access in separate thread using CultureInfo, but that made no difference.
Thread.CurrentThread.CurrentCulture = new CultureInfo("en-GB");
Thread.CurrentThread.CurrentCulture = new CultureInfo("de-DE");
If I start the MessageBox - it shows in correct regional settings as I set with CultureInfo, but when I start the application (Access, Excel, etc.) - it opens in the original user settings...
Does anyone know a way ho to change user's regional settings with C# somehow?
P.S.: I know that it's not recommended practice, but sometime we have to do what we have to.
Thanks everyone!