I'm currently building an application to schedule processes on the TeraData Warehouse - however I need to maintain reporting functionality, as well as real time information availablity.

To provide the reporting, I want my users to log their resource requests into Access
To provide real time information, I want access to post new appointments into Outlook.

I can manage references etc., but what I really want to do is to allow the users to see the specified outlook calendar entries in Access - ideally in the same way that the weekly view in outlook appears.

Any suggestions?