Access 2007 dates transposed on input
Posted on 2011-10-07
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!