Synchronize Outlook 2003 with Access

[Roland Sommer]

Hi,

I'm trying to synchronize my Outlook Items with Access. Therefore I
wrote a small script, that check each Outlook item against its entry
with Access. While it is working perfectly, it takes too much time of
course, so now I want to use events within Outlook to send only new,
modified or deleted items to Access.

I did a lot of tests and didn't find a satisfying solution. It's no
problem to work on new items using application's NewMailEx event.
Trapping changes isn't that easy, because I have to set a WithEvent
script for each folder (I'm afraid of modifing my scripts everytime I
modify my folder's struture). But most annoying is the lack of proberly
recognizing item deletions. Of course there is an event ItemRemove, but
this is fired after the item(s) is/are deleted and therefore I have no
chance to update Access for deleted items only.

Did I miss something? Or am I completely wrong with my idea?

TIA
Roland

[Ken Slovak - [MVP - Outlook]]

Unfortunately with Outlook 2003 those events are all you have. You can
handle ItemAdd on the Items collection of the Deleted Items folder, which
will tell you what item was deleted if it wasn't hard deleted to bypass the
Deleted Items folder (Shift+Delete).

If you were using Outlook 2007 you could use the new BeforeItemMove() event,
which tells you an item is about to be deleted or moved (if the target
folder is null the item is about to be deleted. That event can be subscribed
to on a folder by folder basis.
--
Ken Slovak
[MVP - Outlook]
http://www.slovaktech.com
Author: Professional Programming Outlook 2007.
Reminder Manager, Extended Reminders, Attachment Options.
http://www.slovaktech.com/products.htm

Post by Roland Sommer
Hi,
I'm trying to synchronize my Outlook Items with Access. Therefore I
wrote a small script, that check each Outlook item against its entry
with Access. While it is working perfectly, it takes too much time of
course, so now I want to use events within Outlook to send only new,
modified or deleted items to Access.
I did a lot of tests and didn't find a satisfying solution. It's no
problem to work on new items using application's NewMailEx event.
Trapping changes isn't that easy, because I have to set a WithEvent
script for each folder (I'm afraid of modifing my scripts everytime I
modify my folder's struture). But most annoying is the lack of proberly
recognizing item deletions. Of course there is an event ItemRemove, but
this is fired after the item(s) is/are deleted and therefore I have no
chance to update Access for deleted items only.
Did I miss something? Or am I completely wrong with my idea?
TIA
Roland
--
Die Deppenapostroph-Epidemie weitet sich aus! Wer mitspielen will,
findet z.B. hier http://einklich.net/etc/apostroph.htm eine "Anleitung".
"unterweg's mit Paul's Auto's" ist aber wirklich schwer zu toppen.