Access does not save a datetime field in any format. It always stores a
date as a number. The integer portion is the number of days since Dec 30,
1899; the decimal portion is the fraction of a day. For example right now
if I entered a date into Access, it would store
37945.5381712963
How it is displayed to you is dictated by the format settings.
Dates can be entered as dd/mm or mm/dd. I'm not sure if 01/08/03 is August 1
or Jan 8, or what? Access does not make random decisions about this, it
uses the short date settings on your computer to assume what you mean by
your entry.
So on one computer it could be interpreted one way, and on another computer,
a different way.
Go into Control Panel, Regional Settings, Date tab, and see what your
computer is set to. If it is
m/d/y and you enter 08/05/03, it will assume you mean Aug 5. However if you
enter 13/05/03, that
doesn't conform to your Regional Settings (there is no 13th month). Access
will still enter a date
for you though - it 'helpfully' spins your entry around until it can make
sense of it - May 13,2003.
This is why it can be very confusing to users, as it would appear that
Access arbitrarily changes
your date entries. It's really only doing this after the 12th of the month.
Change your Regional Settings to suit how you like to enter dates. I would
also suggest you choose
a format for your field/control that is unambiguous such as dd/mmm/yyyy.
This way you will see
immediately whether Access interpreted your entry as you meant.
For more information on dates see
http://users.bigpond.net.au/abrowne1/ser-36.html