Synchronize Access Table with Outlook Calendar Appointments

Status
Not open for further replies.

athena2014

New Member
Outlook version
Outlook 2013 64 bit
Email Account
IMAP
Hello,

We have an Access database which includes employees activities in a Table.
We would like to link this Table to an Outlook Calendar Appointment form, so that activities could be setup from Outlook and easily modified from the Calendar (i.e. moving an activity to the next day, etc.).

Could I receive assistance in synchronizing the Access Table to an Outlook custom Appointment form?
We use the latest Office 2013 and Office 365; this database is stored locally.

Thanks a lot!
 

athena2014

New Member
Outlook version
Outlook 2013 64 bit
Email Account
IMAP
Thank you Michael for the prompt reply. I am willing to do the work and to put time into it if I could be given some guidance.
 

Michael Bauer

Senior Member
Outlook version
Outlook 2010 32 bit
Email Account
Exchange Server
First I'd create a copy of the Access table that you do your tests with.

One question you need to think about is how to identify an Outlook appointment in the table. In Outlook you can have two different IDs both with pros and cons:
1. EntryID: The id is unique but it can change when you move the item to another folder.
2. Search_Key: It doesn't change but it is not unique, when you copy the item, the Search_Key property is copied, too.

Some useful events to recognize changes in the calendar are: ItemAdd, ItemChange, BeforeItemMove.

With the "Microsoft ActiveX data Objects x.x Library" you can edit Access tables.
 
Status
Not open for further replies.
Thread starter Similar threads Forum Replies Date
O Synchronize safe persons Outlook 2016 -> Outlook Web Access (OWA) Using Outlook 30
Diane Poremsky Synchronize Quick Access Toolbar and Ribbons? New Slipstick.com Articles 0
C Synchronize outlook with access Using Outlook 1
P Synchronize Outlook.com Contacts among 3 Email Accounts Using Outlook 3
R Cannot Synchronize Outlook To Windows Live Hotmail Account Using Outlook.com accounts in Outlook 2
T Synchronize outlook appointments through web application. Using Outlook 1
M Outlook 2013 folders - don't want to synchronize with email provider's server Using Outlook 15
G Synchronize outlook contacts and calendar with other pc for free Using Outlook 4
P Sync Center appointments failed to synchronize Using Outlook 1
R Hotmail won't synchronize with Outlook Connector Using Outlook 2
R How to synchronize emails between laptop and desktop. Using Outlook 1
M Is it possible to have a public calendar map on a exchange server 2007 and synchronize this map and the items with outlook 2011 for MAC public map bro Using Outlook 2
D Error Code 0x8004003 Unable to synchronize due to hierarchy of folders? Using Outlook 4
M Cannot synchronize with the Outlook profile you are using, because a different profile was previousl Using Outlook 1
T How do i synchronize my outlook 2007 contacts with the contact list in live? Using Outlook 5
D Synchronize Outlook 2010 with new ISP and email address configuration. Using Outlook 1
D reported error (0x800CCCD2) : 'Outlook cannot synchronize subscribed folders Using Outlook 1
T synchronize calendar with .ics extension to my blackberry bold Using Outlook 1
K Synchronize with phone Using Outlook 1
N Getting a popup about an expired *.office.microsoft.com certificate when my internet shared calendars attempt to synchronize Using Outlook 1
S cannot synchronize my Blackberry Calendar and Contact...error message reads no message stores__ Using Outlook 1
O Marked as read cannot synchronize between Outlook and hotmail? Using Outlook 1
O Question about synchronize between Outlook and hotmail account? Using Outlook 2
J Synchronize Outlook 2007 with Outlook 2003 is Unreliable Using Outlook 4
Q Re: Cannot synchronize local replica of mail file with Blackberry Outlook VBA and Custom Forms 1
D Lost Access to Custom Form Outlook VBA and Custom Forms 4
Jennifer Murphy Grant R/W (update) access to a friend Using Outlook 3
O The page that you are trying to access cannot be loaded. Using Outlook 0
T Render Outlook emails in MS access as they appear in Outlook Outlook VBA and Custom Forms 2
T Outlook "A program is trying to access Outlook" Using Outlook 3
GregS Can't access archive file Using Outlook 5
J What is the best EntryID format to set on MS Access table Outlook VBA and Custom Forms 3
J No access to a Database BCM BCM (Business Contact Manager) 3
R How can I access my emails from corrupt offline files of MS Outlook ? Using Outlook 1
V Change default default save location to Quick Access Using Outlook 1
R Quick Access view in File Explorer when saving attachments Using Outlook 0
D Disable or hide "reply" and "reply to all" and "forward" in email from access vba Outlook VBA and Custom Forms 1
J Open an outlook email by Subject on MS Access linked table with VBA Outlook VBA and Custom Forms 10
G Windows Update Causes BCM Database Access Problem? BCM (Business Contact Manager) 4
D populating listbox on custom form from Access Outlook VBA and Custom Forms 7
K How to access emails found to be located in "Top of Outlook data file"? Using Outlook 3
R Categorize Button in Quick Access Toolbar Disappears on New Email Using Outlook 1
O Outlook Web Access - how to disable spam filter Using Outlook 6
T Lost access to remote BCM database BCM (Business Contact Manager) 4
F Outlook 2016 bulk email from access Outlook VBA and Custom Forms 3
J Programmatic access grayed out Using Outlook 10
G Can't open .pst. Message could not access default folder (Outlook 2010 (.pst). Before that was backi Using Outlook 0
D Creating an outlook session from Access vba but run silently. With A specific profile Outlook VBA and Custom Forms 1
T Cannot access outlook.com accounts in Outlook 2016 Using Outlook 1
B Can't expose sender email address when linking outlook to access Using Outlook 3
Similar threads


















































Top