how to read/update exchange 2007 calendars from MS Access

Question

Hi,

We have Exchange 2007 and have a need for quite complex group scheduling. Group scheduling is useless if the people invited do not see it in their Outlook Calendar of course. The data about when those appointments are to take place and who should be there live in an Excel or Access application. I bought the Microsoft book "Inside Microsoft Exchange Server 2007 Web Services" and see a lot of web services examples that pretty much assume I know visual studio. In my case I have not done much programming in 15 years and hope to find a way that allows me to connect Access 2007 directly to Exchange 2007 data, not needing to a third complex part in the middle. I have also read an Access book back to front and have an Access programming book, examples there do not seem to talk about Exchange web services?

In short can one (programmatically) talk to Exchange our Outlook appointment information from an office application like MS Access?

Thank you Bart

Answer 1

Yes. You can use CDO to talk to Exchange 2007 from MS Access 2007.

This MS support article might be useful.

Answer 2

In this post, there is some sample VBA, which may help. It is also possible to link Exchange tables directly to Access, using Get External Data->Link and selecting Exchange.