Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Linking to / Using an Outlook calendar

Posted on 2013-05-15
4
Medium Priority
?
678 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 10

Assisted Solution

by:Marshal Hubs
Marshal Hubs earned 1000 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 1000 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

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Stellar Exchange Toolkit: this 5 in 1 toolkit comes loaded with mega-software tool. Here’s an introduction to tools’ usage and advantages:
There can be many situations demanding the conversion of Outlook OST files to PST format and as such, there is no shortage of automated tools to perform this conversion. However, what makes Stellar OST to PST converter stand above the rest? Let us e…
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an anti-spam), the admin…
Suggested Courses
Course of the Month10 days, 11 hours left to enroll

886 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