Access Linked Tables to Outlook/Exchange-Server

T

Tom Wickerath

An interesting question, posed to an
internal "DevTalkAccess" e-mail list at the company I work
at, is shown below:
_____________________

Sent: Wednesday, May 26, 2004 3:38 PM
To: DL DevTalkAccess; DL DevTalkOffice
Subject: Access Linked Tables to Outlook/Exchange-Server

Hi all,

When I link from Access to Outlook/Exchange-Server,
the "tables" are missing essential data (for example, the
Calendar "table" does not include Location, Start Time or
End Time.) Am I missing a step here or is there something
else I can do?

_____________________

I tried linking to my calendar table and I have verified
that the location, start time and end time are missing
fields. It doesn't seem reasonable that these fields
would be made unavailable, due to concerns about virus
writers using such information (as opposed to e-mail
addresses).

I found an example of doing the same thing, using VBA
code, in KB 275262:

ACC2000: How to Retrieve Exchange and Outlook Data with
the Jet 4.0 OLE DB Provider
http://support.microsoft.com/?id=275262

I made some changes in the code so that it would print out
all fields for the last appointment:

With ADORS
.Open "Select * from Calendar", ADOConn, adOpenStatic,
adLockReadOnly
' .MoveFirst
.MoveLast
For i = 0 To .Fields.Count - 1
Debug.Print i & ".", ADORS(i).name, ADORS(i).Value
' Debug.Print ADORS(3).name, ADORS(3).Value
' Debug.Print ADORS(10).name, ADORS(10).Value
Next i
.Close
End With

However, the location, start & end times are still not
included.

The following KB article shows one how to add an
appointment to Outlook, including the location, start time
and end time:

ACC2000: How to Use Automation to Add Appointments to
Microsoft Outlook
http://support.microsoft.com/?id=209963

But how can I retrieve this information from an existing
appointment?


Thanks,

Tom
 
Top