By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,837 Members | 1,766 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,837 IT Pros & Developers. It's quick & easy.

Regional settings - prevent changes

P: n/a
Hello,

Is there a way in which users can be prevented from making changes to
regional settings in Win XP Professional edition so that the
interpretation of dates by an Access application remains consistent for
all users?

Thanks

Isaac

Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
previously wrote:
*From:* is********@yahoo.com
*Date:* 9 Dec 2004 00:52:41 -0800

Hello,

Is there a way in which users can be prevented from making changes to
regional settings in Win XP Professional edition so that the
interpretation of dates by an Access application remains consistent for
all users?

Thanks

Isaac

This should not be necessary. (And in any case, why would users be
changing their regional settings?)
If the date is manually entered correctly according the user's local
settings then it will be displayed correctly on any other user's machine.
Always format date entry fields on forms with month names (medium or long
date) so that visual confirmation of the entry is simple.

The issue with dates arises in VBA and SQL where it is necessary to force
dates into an unambiguous format for code-based data entry (for example
in SQL queries), otherwise they will be assumed to be in mm-dd-yy format,
if this produces a valid date.
You can do this by always formatting the date as yyyy-mm-dd for entry as
this will never be misinterpreted.

Peter Russell
Nov 13 '05 #2

P: n/a
You can get consistent result without having to tie your users into
straightjackets. It's just a matter of understanding how Access interprets
dates.

For a discussion about the 3 cases where Access can misunderstand your
dates, see:
International Date Formats in Access
at:
http://members.iinet.net.au/~allenbrowne/ser-36.html
The article comes out of 12 years experience using Access in a country that
has a different date format than the US.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

<is********@yahoo.com> wrote in message
news:11*********************@z14g2000cwz.googlegro ups.com...

Is there a way in which users can be prevented from making changes to
regional settings in Win XP Professional edition so that the
interpretation of dates by an Access application remains consistent for
all users?

Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.