Is there any way we can link outlook and access.
The task is to pull information from different MS Outlook calendars(of diff people) and put them in a single new calendar. So that people can see multiple people's schedules at a single place.
For this I guess we need to connect to Outlook frst and access the outlook calendar information and then populate that date in a new calendar... can we do this? Thanks in advance for your answer/help.
My understanding is that sharing calendars only works when using Exchange Server (or some other third-party utility). I'm not aware that they can be shared with everyone using personal stores but if you know how please let me know.
In any case you could probably do it using Access as an automation server and create a PST on the server that stores the shared calendar. Then write code to pull appointment items into the shared calendar from each users calendar. You might want to create a table in Access that holds the names of users and the paths to their calendars (definitely don't hard code it).