none
Access Link Table with Outlook Problem

    Question

  • Hi,
    I'm having problem in create a link table that retrieve task from Outlook.
    It can create a table.
    But with nothing in it, except the %Complete data.
    The rest of field were empty.
    Does any have any idea about this ?
    Or, Would you mind to show me on how to create a link table in access that retrieve Task from Outlook , which including start date/end date?

    Regards,
    David
    Tuesday, September 20, 2005 3:50 AM

Answers

All replies

  • Per one of our support engineers:

    Without programming, you can add a table linked to an Outlook or Exchange folder to any Access database, using drivers built into Office 2000 (or later), by following these steps:

    1. In Access, click the New Table button to add a new table.
    2. In the New Table dialog, choose Link Table, then click OK.
    3. In the Link dialog, under Files of type, choose Outlook() or Exchange().
    4. If you're prompted for an Outlook profile, indicate which one you want to use
    5. In the Link Exchange/Outlook Wizard, choose the address book or folder you want to link to, then click Next.
    6. Give the linked table a name, then click Finish.

    See the MSKB article OL2000 - How to Use Your Outlook Items with Other Office Programs(http://support.microsoft.com/?kbid=196873 ) for more information.

    Unfortunately, this method has at least three huge limitations(like you have come up with): 

    • The linked table ignores any custom fields. 
    • Not all address fields are linked. The  Home and Office addresses each are listed as one field, while the Business address -- probably whatever is the default mailing address -- is parsed into its street, city, etc. components.
    • Not all fields are included for all items -- not even all essential fields. You can see the fields available by switching to Design View.

    Michael Kaplan wrote articles in the August and September 2000 issues of the Smart Access newsletter that explain how to get around the above limitations and make this method work much better.  The August article is available on MSDN -- The Jet 4.0 Exchange/Outlook IISAM. ( http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsmart00/html/sa00h12.asp )

    Also you can import/export outlook items to access programmatically.Here are some information/sample.I hope it can be useful.

    1.       OL2000: How to Programmatically Import Outlook Items from Microsoft Access

    http://support.microsoft.com/kb/208232/

          2.    How to programmatically export Outlook items to Access

              http://support.microsoft.com/?kbid=290792

    1. [code samples] Easy Task Reports with Outlook and WordProcessingML

         http://msdn.microsoft.com/office/downloads/codesamples/default.aspx?pull=/library/en-us/dnofftalk/html/office06012004.asp

    4.  [code samples] Using Automation in Microsoft Office Access 2003 to Work with Microsoft Office Outlook 2003

         http://msdn.microsoft.com/office/downloads/codesamples/default.aspx?pull=/library/en-us/dno2k3ta/html/odc_ac_olauto.asp

     
    I hope this is helpful,
    -brenda (ISV Buddy Team)

    Friday, September 30, 2005 6:06 PM
  • It is great to hear a response to this long time issue - the inability to connect to Outlook stores with access to all fields.

    The ability to attach to Exchange/Outlook tables is something I have wanted for a long time, and frankly have become a little annoyed at.

    Why is it that the Microsoft "link" does not work properly, and why has it never been fixed??

    I mean the original (Access97) had a bug in it due to the datatype (long integer) of the mapitag variable which to the best of my knowledge cannot be worked around, and so we are left with having to code our own solutions rather than simply Linking/connecting to the store from Access.

    Does anyone know how to make the builtin access connection work? Or if it will ever be fixed??


    Monday, October 10, 2005 5:02 AM
  • I don't think is possible as you can see from the above reply.
    What you need is to do coding on Microsoft VBA to load outlook tables.
    There is not shortcut in here, probably the shortage of Access / Outlook.

    Monday, October 10, 2005 5:11 AM