 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Outlook / Contacts / January 2004ADO Connection String
What is the ADO connection string used to open Outlook 11 with JET? 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. -- Ken Slovak [MVP - Outlook] http://www.slovaktech.com Author: Absolute Beginners Guide to Microsoft Office Outlook 2003 Reminder Manager, Extended Reminders, Attachment Options http://www.slovaktech.com/products.htm > What is the ADO connection string used to open Outlook 11 with JET? 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 > See http://www.slipstick.com/dev/database.htm. > [quoted text clipped - 13 lines] > > > What is the ADO connection string used to open Outlook 11 with JET? 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. -- Ken Slovak [MVP - Outlook] http://www.slovaktech.com Author: Absolute Beginners Guide to Microsoft Office Outlook 2003 Reminder Manager, Extended Reminders, Attachment Options http://www.slovaktech.com/products.htm > Ken - thanks for the tip. The problem I have is that most of the articles > reference exchange server like this code fragment. [quoted text clipped - 5 lines] > & "PROFILE=MS Exchange Settings;" _ > & "TABLETYPE=0;DATABASE=C:\WINDOWS\TEMP\;" > .Open > End With [quoted text clipped - 4 lines] > Thanks, > Fred Jacobowitz |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.