Linking an Access Table to Outlook or Exchange

M

Micah Chaney

I am trying to Link an Access Table to a Contacts form in Outlook's Public
Folders. If I choose "Files of Type" Outlook() I can see all the information
just fine, however, other users of the database not on my station cannot.
The link is unavailable. If I choose "Files of Type" Exchange() everyone can
view the same two Fields and I need more than those two fields to import.
I'm wondering is there a way to perhaps link these two programs and have that
linked data stored on some sort of shared path. Maybe if I create the link
from the server or something? Please help. I'm using Access, Outlook, and
Exchange 2003.
 
D

david epsom dot com dot au

Both the 'exchange' and the 'outlook' links, link to the
program Outlook on the PC of the user. What they see when
they look at the link depends on the details of the connect
string, and how Outlook is set up on their PC. Look in
the hidden system table MsysObjects to se what the connect
string looks like, or look at
CurrentDB.Tabledefs("your link name").connect

If you are using Exchange Server, and it is using SQL
Server as the data store, you might be able to link to
the SQL Server, but I haven't seen any documentation.

(david)
 
Top