Accessing Outlook/Exchange contacts - Best Strategy

  • Thread starter Thread starter Atlas
  • Start date Start date
A

Atlas

Digging around I've found that there is no way to access Outlook/Exchange
data using the .mdb/linked table wizard technique, that is you have to code!

There's a quite simple sample on MS explaining how/to @
(http://support.microsoft.com/kb/290792/); basically it shows how to move
data between a table and Outlook.

Assuming I'd like to update data on the Exchange Server, that means I need
to read and update data from a SQL server table.

Apart form thinking about the effectiveness of this technique, also
wondering if there's a less complex method to acheive the same result,
considering also the multiuser environment......

Regards
 
For what I know, Exchange doesn't use SQL-Server as its backend database.

You should ask your question in a newsgroup about Exchange, not in one about
ADP. You will probably find that going this way is probably more
complicated then accessing Outlook.
 
Sylvain Lafontaine said:
For what I know, Exchange doesn't use SQL-Server as its backend database.

Glad you know, I did allready.
You should ask your question in a newsgroup about Exchange, not in one
about ADP. You will probably find that going this way is probably more
complicated then accessing Outlook.

Sorry about you thinking this post is OT but it it isn't at all.

We are taking about Access->Exchange, not generic exchange topic.

And we're talking .adp.

And you should read the MS article I was talking about!

Bye
 
ADP best methods for utilizing Exchange

I actually am interested in this subject as well. Mostly in what are the best methods for single sourcing a public contact list from out look with your ADP application?

I once looked into making ADO connection to exchange 5.5. This proved to be difficult. Exchange doesn’t use a SQL standard relational database. It looks to me more like a LDAP server that is built for massive storage of simple lists.

I also had some success using WebDAV to connect to exchange. However, it was taking to much time so I moved on. Now I have contacts in my adp and exchange server. This will eventually become a big headache to merge this information together.
 
Back
Top