Generalised Outlook/Exchange Interface

[Brian McGuigan]

I am trying to develop a generalised interface to enable
Access to open Folders as Tables inside Access' so that I
can write a synchronisation routine between my Application
and any version of Outlook, whether it is linked to
Exchange or not.

I linked manually to Outlook on my development PC and got
a connection string:
Outlook 9.0;
MAPILEVEL=Mailbox - Brian McGuigan|;
PROFILE=In the Office;
TABLETYPE=0;
TABLENAME=Contacts;
DATABASE=C:\DOCUME~1\Brian\LOCALS~1\Temp\;
TABLE=Contacts

So I wrote a routine that uses:
strTempDirectory = Environ("Temp") & "\"
strConnect = _
"Outlook 9.0;" & _
"MAPILEVEL=" & GetMailboxName & "|;" & _
"TABLETYPE=0;" & _
"TABLENAME=Contacts;" & _
"DATABASE=" & strTempDirectory & ";" & _
"TABLE=Contacts"
This works fine on my PC.

The problem is this seems to be at variance with the
standard advice that I should have been using 'Exchange
4.0' as my Identifier, and the name of my Database, as the
Database Name argument - neither of which result in a
connection that works on my PC. So why the differences?

How do I generate connection strings so that they will
connect to any version of Outlook from 97 on - even if
Outlook is linked to Exchange?

 

[Mingqing Cheng [MSFT]]

Hi Brian,

I have noticed that MVP Sue Mosher had added some value and it resolved
according to your reply in the newsgroup
microsoft.public.outlook.program_vba. I will close monitoring this thread
now. Please feel free to let me know if you want further assitance on this
issue or you have any concerns on this issue.

Thank you for your patience and corperation.


Sincerely yours,

Mingqing Cheng

Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center