Dates??

  • Thread starter Thread starter Carlos
  • Start date Start date
C

Carlos

I have a database that is being shared by 5 users. The
front end is saved on each persons c Drive and the tables
are on a network. They all have the same version on their
desktops but when 2 users save there records the date
field saves and displays differently. I have it so that
it should save 11/1/2003 but on these two users machines
it shows as 1/11/2003. Im assuming it is an Access level
setting that needs to be changed but I dont know what.

Help!!
 
It is pc setting, and NOT a ms-access setting.

Dates are stored in some special "internal" format. This of course was a
VERY WISE decision on the developers of ms-access, since then each user has
a choice of how the dates will be displayed.

Since everyone has their own preference, then your code and your designs
MUST NOT assume any particular format. The ONLY THING you need to make sure
of is that your field is in fact a true date type field.

So, check the control panel, and the regional settings on those computers.
You can set the date format as you like.

You should realize that in you VB code, you MUST use the use the 'USA'
format for sql query's you built.. Thus, you code needs to use dates of:

#mm/dd/yyyy#

Format.

However, the above rule ONLY applies to your in-line sql code. For the rest
of your application, the dates simply displays as your users want them to,
and that setting is in the control panel in the regional settings, and NOT
in ms-access.
 
Back
Top