Access 2003 and new DST in 2007

N

nicolas.gendron

Hi,

I'm working on an application that is using DAO to create an Access
Database.
The application creates a table and put the current date and time in a
field of this one.

myRecordset.m_currentTime = COleDateTime(currentUtcTime);

When I'm opening the table it displays the time in local time. The
problem is that it seems that the new DST wasn't applied.

* My computer has the Microsoft DST 2007 update installed.

Any help would be greatly appreciated.

Thanks a lot.

Nic
 
J

James A. Fortune

Hi,

I'm working on an application that is using DAO to create an Access
Database.
The application creates a table and put the current date and time in a
field of this one.

myRecordset.m_currentTime = COleDateTime(currentUtcTime);

When I'm opening the table it displays the time in local time. The
problem is that it seems that the new DST wasn't applied.

* My computer has the Microsoft DST 2007 update installed.

Any help would be greatly appreciated.

Thanks a lot.

Nic
Click to expand...

In:

http://groups.google.com/group/comp.databases.ms-access/msg/f06bd4c45037ef29

Lyle Fairfield said:

:I !!!!!think!!!!! that unless something changes these registry settings
:(below) on my computer then the changes will be made in the first week
:eek:f April and the last week of October.
:
:Will something change them automatically? I'd guess that MS or Nist or
:someone else will send out a reg file or patch we can import that will
:do this.
:
:
:If not they can be edited manually in regedit (maybe not a good idea
:for the not-so-brave)


I am running Windows 2K SP4 with all the updates. Before I changed two
registry settings my clock kept reverting back from DST about every
hour. The changes I made (untested except that I haven't had any
problems yet and use at your own risk):

Value 3 (Standard Start)
Old Value: 0a 00 05 00 02 00
New Value: 0b 00 01 00 02 00

Value 6 (Daylight Start)
Old Value: 04 00 01 00 02 00
New Value: 03 00 02 00 02 00

I'm guessing that this change will start DST on the second Sunday of
March at 2:00 a.m. and revert to actual time on the first Sunday in
November at 2:00 a.m.

I hope this helps,

James A. Fortune
[email protected]
 
Top