By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,561 Members | 3,083 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,561 IT Pros & Developers. It's quick & easy.

Outlook Addressbook and Access ADP Project

P: n/a
I know if I was using an Access MDB I could link to MS Outlook folders
and the addressbook. But I'm using an Access Project (ADP) and want to
figure out a way to link to the Outlook addressbook this in code. I'm
hoping someone has an example of how to accomplish this, through CDO
or otherwise.
Thanks,
lq
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
SA
Lauren:

In an ADP, you can import the address books pretty simply by using the Get
Exernal Data command from the file menu. But of course this does support
linking like it does in an MDB. To work around that, if you really wanted
to, you could create an mdb db, link to the outlook address book through
that db and then use that db as a linked server to your SQL db; but of
course you'd need a huge number of links if you've got multiple users (or
link to an exchange server).

You can use CDO to access the address books, but keep in mind if you attempt
edit or add items, and you are using Outlook 2000 with the security update,
2002 or higher, you'll get security warnings with your users when you use
the CDO libraries. Certainly not optimal

You can look at http://www.cdolive.com/start.htm for numerous examples. If
you can't find what you need to get you started there, we've got an old A97
db that can pull the info out of any outlook address book in read only
scenario using CDO that could get you started, the code is generic so it
would work in newer versions of Access as well. You can find our e-mail
address on our web in the contact area if you need a copy.
--
Steve Arbaugh
ACG Soft
http://ourworld.compuserve.com/homepages/attac-cg

"Lauren Quantrell" <la*************@hotmail.com> wrote in message
news:47**************************@posting.google.c om...
I know if I was using an Access MDB I could link to MS Outlook folders
and the addressbook. But I'm using an Access Project (ADP) and want to
figure out a way to link to the Outlook addressbook this in code. I'm
hoping someone has an example of how to accomplish this, through CDO
or otherwise.
Thanks,
lq

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.