ADO Connection String

[Fred Jacobowitz]

What is the ADO connection string used to open Outlook 11 with JET?

 

[Ken Slovak - [MVP - Outlook]]

See http://www.slipstick.com/dev/database.htm.

I assume you mean you want to connect to Outlook using an ODBC
connection? Just remember that many fields aren't available when doing
that (you only get 44 fields from a contact item for example) and that
field names in the recordset don't match the Outlook property names in
many cases.

 

[Fred Jacobowitz]

Ken - thanks for the tip. The problem I have is that most of the articles
reference exchange server like this code fragment.

With ADOConn
.Provider = "Microsoft.JET.OLEDB.4.0"
.ConnectionString = "Exchange 4.0;" _
& "MAPILEVEL=Mailbox - James Smith|;" _
& "PROFILE=MS Exchange Settings;" _
& "TABLETYPE=0;DATABASE=C:\WINDOWS\TEMP\;"
.Open
End With

Do you know what the connection string should look like for a 'home' pc
running Outlook?

Thanks,
Fred Jacobowitz

 

[Ken Slovak - [MVP - Outlook]]

I use something like this:

.Provider = "Microsoft.JET.OLEDB.4.0"
.ConnectionString = "Outlook 9.0;" _
& "MAPILEVEL=Mailbox - Ken Slovak|;" _
& "PROFILE=Ken Exchange;" _
& "TABLETYPE=0;DATABASE=C:\TEMP\;"

But that refers to an Exchange mailbox and an Exchange profile. You
can try replacing the mailbox name with "Personal Folders" and replace
the profile name and see if that works. And make sure that the Temp
folder location is correct for your setup or create a new Temp folder
where you want and reference that in the connection string.

The Exchange string might also work if you replace the mailbox name
with "Personal Folders" and fix the profile name.