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.
Similar threads
Thread starter Title 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
Q Re: Cannot synchronize local replica of mail file with Blackberry Outlook VBA and Custom Forms 1
Fozzie Bear Shared Public Folders Access and Use Exchange Server Administration 0
G How to add a folder shortcut to outlook quick access toolbar? Using Outlook 6
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
Diane Poremsky Change Outlook's Programmatic Access Options New Slipstick.com Articles 0
S how to access the properties of a contact given distlist.member object Outlook VBA and Custom Forms 1
C OWA External Access - No URL / URL Invalid Exchange Server Administration 2
G Adding a contact to Outlook with a custom form using Access VBA Outlook VBA and Custom Forms 1
C Merging Word and Access into Outlook Using Outlook 4
I Outlook 2016 and Slow access to Outlook.com IMAP Using Outlook 0
B No permission to access Outlook.pst file Using Outlook 1
Norbert VBA Flag that would indicate the email was sent from Outlook to Access. Outlook VBA and Custom Forms 2
M Cannot access the Form Editor BCM (Business Contact Manager) 1
R The changing way to access information in Office 365 New Slipstick.com Articles 0

Similar threads

Top