My simple question is: how can I programmatically find out from within Access 2007 what option was selected on the top dropdown of the Regional Options tab of the Regional and Language Options Control Panel in Windows?
Describing my issue more fully:
Some time ago, from a question I posted which I cannot find now, I got some Encryption/Descryption code.
I have an Access 2007 based app that reads some encrypted information from an external "config" file, decrypts it and uses it to establish a connection to a SQL Server. This has worked fine for my regional settings (English - U.S.), but now I have users with different regional settings and the encryption/decryption does not work properly for some of those settings, notably Czech and Vietnamese.
My solution is to set up my config file with multiple rows of encryptions, one for each regional setting that might be used. Then, I could set my computer to each of those regional settings and encrypt the data and place it in the file. Then, when I bring in the config data, I could search the data for the correct row and run the decryption, which would now be correct because the encryption was created with the same language settings.
But I need to be able to find out what the resgional setting is for the machine on which the application is being run. HOw do I do that?