Link to Outlook Calendar from Access

[MikeP125]

Hi,
I need to create and modify Outlook Appointments from an Access database. I
can use the File-Get External Data-Link Tables command, then choose Exchange
and link to my calendar, but the start date, start time, end date and end
time fields are not visible in the table. Also, there is no key field or
unique identifier such as an ID field.

Can anyone give me some direction on how to lionk my Access table to this
Outlook Appointment table and make changes to the dates and times from Access?
Thanks,
Mike

 

[David H]

1) You're better off using Automation to connect to Outlook as opposed to
linking to the store.

2) A very common misconception is that the .EntryId propery of the
AppointmentItem is analogous to a primary key in Access. The .EntryId is not
a guaranteed means to reference an AppointmentItem as there are certain
conditions underwhich it can change. Instead, create a User Property and
assign it a unique value which is captured in your Access datababse. If
you're using Access to create the AppointmentItems, you can use the Primary
Key in the Access table, otherwise there are other options. Post back if you
need help with that.

3) The Outlook newsgroup will be the best place to go for help with the
Outlook Object Model.
http://www.microsoft.com/office/com...soft.public.outlook.program_vba&lang=en&cr=US

4) The links below provide sample code that show you how to Automate Outlook
from Access and should get you started.
Create Items from Access
http://support.microsoft.com/default.aspx/kb/290658

Loop through folders and subfolders in Outlook
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_22995423.html

Exporting Outlook Items to Access (Good in terms of showing you how to
reference a particular folder in Outlook which you'll need to know in order
to find the AppointmentItem that you'll be working with. If you're working
with AppointmentItems in a non default folder, you'll use the article above
in order to find the Item.)
http://support.microsoft.com/kb/290792

General Information on Outlook Automation
http://www.databasejournal.com/feat.../3827996/Working-With-Outlook-from-Access.htm

5) Here's a link to the AppointmentItem Object Reference. It'll come in
quite handy.
http://msdn.microsoft.com/en-us/library/bb219939.aspx

 

[MikeP125]

I will look through all of this stuff. Thanks for your help, I appreciate it.