Linking an Access Table to Outlook or Exchange

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top