Access 2002 integration with Outlook

[Stephen]

Does anyone know if there are some good Access or Outlook
Add-on utilities (or built in utilities) that would allow
an Access 2002 database to be linked with the contacts
and/or calendar functions of Outlook? They are both
Microsoft tools so I imagine there are some integration
capabilities.

Thanks in advance.

-Stephen

 

[Sue Mosher [MVP]]

Yes and no. There are tools that allow an Access database to be used as an Outlook address book, but going the other way often takes custom code. The linked table method has major limitations, including the inability to show even all the reasonably important fields. While articles have been written on how to expand on this method's obvious features, I've never been able to duplicate the results. See http://www.slipstick.com/dev/database.htm#linkedtables .

That page will also give you other ideas on how to work with databases and Outlook together.

--
Sue Mosher, Outlook MVP
Outlook and Exchange solutions at http://www.slipstick.com
Author of
Microsoft Outlook Programming: Jumpstart
for Administrators, Power Users, and Developers
http://www.slipstick.com/books/jumpstart.htm