Solved

Linking to / Using an Outlook calendar

Posted on 2013-05-15
4
635 Views
Last Modified: 2013-06-04
We have an Access 2003 database, and need a centralised calendar to update/view activities.  I was thinking of using the Outlook/Exchange calendar.  However, there are two things:

1.  Is this possible to access this Calendar (without those annoying Outlook security messages)
2.  Could we setup a new calendar within Outlook, that everyone can access, but doesn't affect their existing ones.

Thank you.
0
Comment
Question by:Andy Brown
  • 2
4 Comments
 
LVL 9

Assisted Solution

by:Marshal Hubs
Marshal Hubs earned 250 total points
ID: 39167391
You can add a table linked to an Outlook or Exchange folder to any Access database, using drivers built into Office 2000 (or later), by following these steps:

   1. In Access, click the New Table button to add a new table.
   2. In the New Table dialog, choose Link Table, then click OK.
   3. In the Link dialog, under Files of type, choose Outlook() or Exchange().
   4. If you're prompted for an Outlook profile, indicate which one you want to use
   5. In the Link Exchange/Outlook Wizard, choose the address book or folder you want to link to, then click Next.
   6. Give the linked table a name, then click Finish.
0
 

Author Comment

by:Andy Brown
ID: 39167461
Thanks for your quick response, but this seems to cause an error:

Link Exchange/Outlook wizard:
Object or class does not support the set of events:


I created a brand new, Access 2003 (no additional references added). Plus, Outlook is 2007.

Any ideas?
0
 
LVL 74

Accepted Solution

by:
Jeffrey Coachman earned 250 total points
ID: 39170272
<1.  Is this possible to access this Calendar (without those annoying Outlook security messages)>
Can you be more specific here...
The only "Outlook security messages" you should get is when you are using vba automation to send an email.

<2.  Could we setup a new calendar within Outlook, that everyone can access, but doesn't affect their existing ones.>
See these links:
http://office.microsoft.com/en-us/outlook-help/create-view-or-delete-a-group-schedule-HP001230343.aspx

http://www.wikihow.com/Make-a-Shared-Calendar-in-Outlook

JeffCoachman
0
 

Author Closing Comment

by:Andy Brown
ID: 39219177
Thanks guys - in the end I went down a different route.
0

Featured Post

Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Read this checklist to learn more about the 15 things you should never include in an email signature.
In this step by step procedure, you will come to know the details of creating an Outlook meeting in 2007, 2010, 2013 & 2016.
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

828 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question