Winflector.com - forum Winflector

Forum > Product technical support > Date Formats in MS Access

Autor: T.White
Data: 2020-12-30 17:14:30

Hi,

I have an MS Access databse running from a Windows 2012 R2 Server with the regions set to UK and UK format selected for time/date etc. When i run the database locallly on the Server 2012 R2 machine the date formatting is in the UK format, when i run the database on my windows 10 client macine using the Winflector client (all UK format as well) the format coming through in the access databse is the USA format, so MM/DD/YYYY. Also the dimension format in the report designer is in inches instead of mm.

Is there a setting in Winflector client or server that i need to set to over come this?

Many Thanks,

Tom

Autor: Jacek (staff)
Data: 2020-12-31 14:11:34

Hi,

Seems like Access use the WIndows user settings for locale.

Client-side locale setting are not transferred to server by Winflector. Instead, you need to configure proper locale settings for the server user where Winflector server runs (if you use Winflector authentication). If Winflector is configured to run applications as specific Windows user you need to change locale setting for that exact user.

Zaloguj się aby móc pisać na forum.