Hello,
I'm using:
Access 2003 (11.8166.8221) SP3
Outlook 2003 (11.8217.8221) SP3
I found an odd behavior when using File | Get External Data | Link Tables...
| Outlook().
I selected my 'Sent Items' as the table input and it shows up nicely as a
table in my Access Database.
The Odd thing is this:
The "Received" field is the date that the email was sent (normal). Generally
the date is fine. What I noticed was that every time there is an email sent
on the last day of the month in the PM, the date is corrupted.
In one case, the "Received" date should have been 4/30/2009 7:19 PM (that's
what I see in the Outlook email message). When I look at the data in the
Access Table it shows up as 9/14/1618 1:25:36 AM. When I copy (Cntl-C) and
paste (Cntl-V) the data comes out as 1/1/1601.
Most dates are fine. There are 936 records in my file and 10 of them
are corrupted because they were received in the PM on the last day of the
month. It doesn't matter which month it's very consistently the last day of
the month in the PM. If the message is in the AM, the date is fine in both
Outlook and Access.
Has anyone else seen this? Is this a bug in Outlook or Access?
Any help or guidance would be appreciated.
Agent 99
|
Similar Threads
