[AccessD] SQL datetime to Access date conversion

If I remember correctly, Access (I think) uses milliseconds in its time
while SS doesn't.  Or maybe it's the other way around.  Anyhow, I
remember we had to deal with the issue in .Net swapping between the two.
I would check further, but I'm on my way out the door.

Charlotte Foust 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Doug Steele
Sent: Monday, August 31, 2009 3:27 PM
To: accessd at databaseadvisors.com
Subject: [AccessD] SQL datetime to Access date conversion

Hello All:

I have a SQL 2005 table linked into an Access db.  I am using an update
query in Access to move some datetime fields from SQL Server to an
Access table.  It almost works - the dates are OK, but I am getting
times which are sometimes out by a couple of minutes: for instance the
time part of one field, 2:00:00 PM in SS, is changed to 1:58:07 PM in
Access.

Does anyone have any suggestions about why this happens?

Thanks,
Doug Steele
--