linking Outlook 2007 calendar to Access 2007

[Kathryn]

I am trying to link bookings in our Acess 2007 database with an Outlook 2007
calendar and started following the Outlook: File > Export/ Import > Import
from another program route ... but my choice for Access only comes up as
Access 1997-2003 which, of course, doesn't find my database!

Does anyone have any ideas on how to resolve this?

Many thanks!

 

[Roady [MVP]]

If you want to setup a link between Access and Outlook, importing is not the
way since that won't be a link.
To create a link, you'll have to set it up from within Access;
Select the External Data tab-> button More in the Import section-> Outlook
Folder

To have it work from your existing Access database or if you want to apply
custom action, then you'll have to use VBA.

 

[Kathryn]

Thanks Robert

I think the "from Access to Outlook" would be the best way round as the
person taking the bookings will be working straight into Access... my thought
was to save the second step of updating the Outlook calendar.

Is the setting up you suggest complicated? I have been working in Access for
a few months but haven't really done any VBA.

Thanks

 

[Roady [MVP]]

The linking can be done is some easy steps from within Access as it is a
wizard.
Setting up VBA can be as complicated as you want it; it all depends on what
exactly you want to do.

A good place to start is;
http://www.outlookcode.com

Or ask in the developer newsgroups "down the hall".

 

[Kathryn]

Many thanks - will have a go!

The linking can be done is some easy steps from within Access as it is a
wizard.
Setting up VBA can be as complicated as you want it; it all depends on what
exactly you want to do.

A good place to start is;
http://www.outlookcode.com

Or ask in the developer newsgroups "down the hall".