I
Ian Crofts
I have been using an Access 2000 adp connecting to a SQL 2000 backend. After
upgrading to Access 2002, any datetime fields with a time only component,
say 8:45 AM now display as 30/12/1899 8:45:00AM. Fair enough to a point, as
Access is supposed to use this as the default date for time values. However,
if I add a time value to one of these fields using the adp under Access
2002, the time displays a time only (ie. 8:45:00AM) in Access. But if I look
at the table in Enterprise Manager the value shows as 1/01/1900 8:45:00AM.
So it looks as though Access is now using 1/01/1900 as the default date. I
can't for the life of me find where this could be configured. The same thing
happens whether the adp is converted to 2002 format or not. Any ideas?
upgrading to Access 2002, any datetime fields with a time only component,
say 8:45 AM now display as 30/12/1899 8:45:00AM. Fair enough to a point, as
Access is supposed to use this as the default date for time values. However,
if I add a time value to one of these fields using the adp under Access
2002, the time displays a time only (ie. 8:45:00AM) in Access. But if I look
at the table in Enterprise Manager the value shows as 1/01/1900 8:45:00AM.
So it looks as though Access is now using 1/01/1900 as the default date. I
can't for the life of me find where this could be configured. The same thing
happens whether the adp is converted to 2002 format or not. Any ideas?