Access 2007 dates transposed on input

Posted on 2011-10-07
Last Modified: 2012-05-12
Have an Access 2007 database deployed on a terminal server (Server 2008).  Back end is Sql Server 2008.  

For most users entering dates, whether typed or picked from the date picker is fine.  For a couple there are 2 issues.  1.  Transposition to US style on entry.  2.  Reversal of date entry i.e. 21/03/11 being trasnposed to 11/03/21

When this was first noticed I had a look at the user profiles, some were set on US location, US keyboard etc., and once changed it solved the problem for a couple of users.  

More interestingly some of the MS Access languages were set to UK, some to US, how does this happen if the server was installed as UK throughout, or so I have been informed by the clients IT support.

There are still 2 users, where no matter what is done the dates are trasnposed on entry, specifically when entered from the keyboard instead of the date picker.

Please note for most users everything is OK!

Question by:Paul-bbc
    LVL 84

    Accepted Solution

    I would suggest you remove those two user Profiles and recreate them, and be very careful to select the correct language settings when doing so. It's possible that you've got some corrupt user profiles.

    < how does this happen if the server was installed as UK throughout, or so I have been informed by the clients IT support.>

    I'm not sure, but I'd bet it has something to do with the virutalization features of the Terminal Services environment. It's possible to install the SERVER as a UK language, but setup a desktop as as US language base.

    LVL 39

    Expert Comment

    You should use this recommendation from Meinolf Weber:
    It will work only for new creted profiles.

    Author Closing Comment

    User profiles were removed, then re-instaled, now all OK with no changes required to Access front end or SQL server db settings.

    Please note that even though it was possible to amend location, keyboard, language etc. at Control panel and Access options level this did not cure the problem, only recreating the profiles from scratch solved the issue.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Find Ransomware Secrets With All-Source Analysis

    Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

    If you migrate a Terminal Server licenses server inside the 2008 server family, you can takte advantage of the build-in migration tool. If you like to migrate an older 2003 Server (and the installed client CALs) to a 2008 R2 server for example, you …
    I originally created this report in Crystal Reports 2008 where there is an option to underlay sections. I initially came across the problem in Access Reports where I was unable to run my border lines down through the entire page as I was using the P…
    This tutorial will walk an individual through setting the global and backup job media overwrite and protection periods in Backup Exec 2012. Log onto the Backup Exec Central Administration Server. Examine the services. If all or most of them are stop…
    With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

    794 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

    17 Experts available now in Live!

    Get 1:1 Help Now