Form dates ignore regional settings Vista Business x64/Access 2010 RT 1

[1DMF]

Hi,

I seem to have a user who cannot enter dates into our DB in a UK format?

All other users work fine, just this Vista x64 user under Access 2010 runtime has the problem.

We have checked, re-checked and checked again the regional settings in the control panel and they are set correctly to UK format, but these seem to make no difference.

Any date typed such as '29/06/11' is displaying as '06/11/2029'?

If typed as USA '06/29/11' it then displays correctly as UK but when mail merges are run the printed date is showing as USA.

Why is this happening and how do we fix it?

Thanks,

1DMF.

"In complete darkness we are all the same, only our knowledge and wisdom separates us, don't let your eyes deceive you."

"If a shortcut was meant to be easy, it wouldn't be a shortcut, it would be the way!"

Google Rank Extractor -> Perl beta with FusionCharts

 

[1DMF]

just to add to the problem, it seems Sage accounting is doing the same thing , all the dates are USA format, but the regional settings are UK?

"In complete darkness we are all the same, only our knowledge and wisdom separates us, don't let your eyes deceive you."

"If a shortcut was meant to be easy, it wouldn't be a shortcut, it would be the way!"

Google Rank Extractor -> Perl beta with FusionCharts

 

[kjv1611]

Honestly, this sounds like it's a system issue, not a database issue. I'd suggest posting in the Vista forum:
forum1583

It makes me think that something is wrong within Windows - data corruption, registry issues, something... that's behind the scenes causing the issues.. But you're more likely to get the right help there, I think.

 

[1DMF]

It was a bizzarre one for sure.

I rung Sage as this was also being affected, they suggested changing the regional settings to another country, rebooting, changing back to UK and rebooting again.

In principle sounded great, only after changing them to Dutch, the client would no longer let me log on as the user with a domain error about there being no trust relationship between the security DB and the workstation!

So we logged on to another client machine running Win7 as the Vista user and the roaming profile came across fine, showing dutch locale.

So we changed it back to UK and logged off again so the roaming profile would copy back to the server.

Tried to log on as the user back on their Vista machine, same domain error.

So I logged onto the local machine admin account , re-assigned the client to the domain and rebooted, then when the user logged on they were back to UK country locale with the Access DB & Sage working correctly with UK regional settings.

What a plaver! But at least I got there!

"In complete darkness we are all the same, only our knowledge and wisdom separates us, don't let your eyes deceive you."

"If a shortcut was meant to be easy, it wouldn't be a shortcut, it would be the way!"

Google Rank Extractor -> Perl beta with FusionCharts

 

[kjv1611]

Words I've learned the hard way:

NEVER EVER say "it'll only take a minute."

 

[kjv1611]

By the way,

What does plaver mean? I'm guessing that either that's a typo or else it's just a UK idea or word? I couldn't find a good reference online, so I'm just curious.

 

[1DMF]

typo!

Palaver

"In complete darkness we are all the same, only our knowledge and wisdom separates us, don't let your eyes deceive you."

"If a shortcut was meant to be easy, it wouldn't be a shortcut, it would be the way!"

Google Rank Extractor -> Perl beta with FusionCharts