How to find out Regional Language setting?

Posted on 2009-04-30
Last Modified: 2013-11-27
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?
Question by:wsturdev
    1 Comment
    LVL 1

    Accepted Solution


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    6 Surprising Benefits of Threat Intelligence

    All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

    Most if not all databases provide tools to filter data; even simple mail-merge programs might offer basic filtering capabilities. This is so important that, although Access has many built-in features to help the user in this task, developers often n…
    Introduction The Visual Basic for Applications (VBA) language is at the heart of every application that you write. It is your key to taking Access beyond the world of wizards into a world where anything is possible. This article introduces you to…
    Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
    What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.

    779 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    16 Experts available now in Live!

    Get 1:1 Help Now