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!
 
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.
 
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? Using Outlook 0
C Synchronize outlook with access Using Outlook 1
H Synchronize contacts and calendars across multiple devices Using Outlook 0
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
Q Re: Cannot synchronize local replica of mail file with Blackberry Outlook VBA and Custom Forms 1
Victor_50 Problem - Google Workspace will stop "unsafe" access to Outlook end 2024 Using Outlook 3
A Quick Access Toolbar Not Showing Description Using Outlook 0
W Outlook 365 File access denied attempting to import .pst Using Outlook 6
J Recover server side rules from OST/PST without access to the server Using Outlook 2
richardwing Outlook 365 VBA to access "Other Actions" menu for incoming emails in outlook Outlook VBA and Custom Forms 0
V How to add 'Previous Item' and 'Next Item' to the Quick Access Toolbar Using Outlook 1
J Text icon in Quick Access toolbar ? Using Outlook 2
Z Import Tasks from Access Using VBA including User Defined Fields Outlook VBA and Custom Forms 0
klpconsulting Programmatic Access Office 365 Pro Plus & RDS Using Outlook 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 Using Outlook 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

Similar threads

Back
Top