Linking to Outlook Problem

[Guest]

I've followed the instructions to link my Access Database to "Contacts" in
Outlook. The instructions say once you are done, you should be able to
update information in Access, and the same record will be updated in Outlook
and vice-versa. However, this isn't happening. It seems to just "export" the
data without really linking the files. Anyone else have this problem? Any
suggestions?

Here's the command series I'm using: File - Get External Data - Link Tables
- then in "files of type" - Outlook - then I go through the wizard, chose the
contacts folder, finish the wizard.

 

[Tom Wickerath]

Hi Trixie,

Just curious where you read the instructions that indicate that the communication path is
two-way. I seem to recall reading in the past--although I'm not positive--that establishing a
linked contacts table was read only.

You can try the following KB sample, which uses VBA code to write items to an Outlook Contacts
folder:

How to programmatically import Outlook items from Access
http://support.microsoft.com/?id=290658

It been a while since I've played with this code, but I seem to remember that it's very easy to
create duplicate contact records in Outlook, simply by running the code a second time. If I'm
remember this correctly, you might want to include a new boolean field to indicate whether or not
the record has been imported to Outlook, and then set a criteria in code to filter out these
records.

Tom
________________________________


I've followed the instructions to link my Access Database to "Contacts" in
Outlook. The instructions say once you are done, you should be able to
update information in Access, and the same record will be updated in Outlook
and vice-versa. However, this isn't happening. It seems to just "export" the
data without really linking the files. Anyone else have this problem? Any
suggestions?

Here's the command series I'm using: File - Get External Data - Link Tables
- then in "files of type" - Outlook - then I go through the wizard, chose the
contacts folder, finish the wizard.