Solved

Linking to / Using an Outlook calendar

Posted on 2013-05-15
4
652 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
4 Comments
 
LVL 10

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

To Patch or not to Patch? That is the question!

Don't get caught out like thousands of others around the world in the recent Ransomware Fiasco!
Discuss..
- Why it's not a good idea to wait before Patching
- Sensible approaches to Patching discussed
- Add your feedback, comments and suggestions

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Add a record to a table when enter value in a combobox 7 32
Missing DLL in Access 2010 11 28
Hybrid Exchange 6 28
Missing Folder in outlook 2013 6 28
Access custom database properties are useful for storing miscellaneous bits of information in a format that persists through database closing and reopening.  This article shows how to create and use them.
Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

734 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