Access 2003 - Access 2002 short time bug

  • Thread starter Thread starter rahaf
  • Start date Start date
R

rahaf

Hi all,

I developed a web site for an institute. The site's database is based
on Access.
The database was placed on the Web Server (not my decision...) in a
shared folder which can be accessed from computers in the institute's
network only.
Another programmer has developed a UI with Access 2002. This UI
enables people from the institute to enter data to the database which
is later used by the site I developed. On the web server we got Office
2003 installed.

The problem is this:
When time is entered through the UI (using Access 2002) with a short
time format (i.e. hh:mm) it somehow changes its format in the Access
2003 environment to hh:mm:ss. If the table with the time field is
opened with Access 2002 one sees the format requested. However, if the
same table is opened using Access 2003, some of the records have the
format hh:mm:ss.
We cannot explain / fix this bug.

It should be noted that a format such as hh:mm:ss does not exist by
its own.
The next possible time format is medium format and it should include
the a.m. / p.m. (i.e. hh:mm:ss A.M.)

As far as the UI is concerned the time can only be entered in s
certain way (i.e. hh:mm). It doesn't allow the user to enter a
different format.

Has anyone encoutered this bug? Your help will be most appreciated.
Thanks,
 
All times have seconds associated with them in all versions of Access. How a
value is display (i.e.: its format) has nothing to do with how it's stored.

Date/Time values are 8 byte floating point numbers, where the integer part
represents the date as the number of days relative to 30 Dec, 1899, and the
decimal part represents the time as a fraction of a day.

And while there may not be a built-in format of hh:mm, you're not limited to
the predefined formats. Simply specify hh:nn as your format, and you should
be fine. (Note that's n, for miNute: m is used for Month)
 
Thank you for your reply.
Well, when I wrote hh:mm I actually meant hh:nn. I forgot to mention
that We did define the time format as short time within the Access
itself but as already mentioned the problems still exists.

Thanks.
 
Back
Top