I am going to post this in an access group as well - however somebody
here probably has a better answer for me.

I have a Ms access table where the user assigns a activity to a date
(eg meeting or holiday etc). I want those dates assigned an activity to
appear as an appointment in outlook. I know how to code to create the
appointment as the user enters the activity for the date in access -
however the user may then change the activity for a certain date at a
later date.

Eg. The user assigns the activity of holiday to the 01/02/2007 in
access. I can create an appointment for this in outlook as this is
done.

However a week later the user might change the activity assgned to
01/02/2007 in the access table from holiday to meeting. I do not know
how to update this information in outlook without creating another
appointment (therefore having an appointment for holiday and for
meeting in the outlook calendar in the same day).

If anybody can help with this I would be very pleased.

Thanks