Results 1 to 4 of 4
  1. #1
    Lounger
    Join Date
    Sep 2006
    Location
    Jhongli, Taiwan
    Posts
    42
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Linking Outlook contacts to Access database (2007 SP1)

    I am having trouble linking Outlook 2007 contacts to a Access 2007 database.

    My contacts are used primarily for recording mobile numbers, which constantly change. New contacts are regularly added and current contacts often move away. Their data is left in the database but a check box (named "Deleted") is used to filter the current contacts datasheet. I would like to somehow get Outlook and Access to talk to each other so that the changes I regularly make in Access can be updated to Outlook. If it is possible to do so, I can then synchronize my mobile phone to Outlook's contacts using Nokia PC Suite 7.0.

    The problem is, I want to have Office 2007 links up and running before installing Nokia's software but I cannot seem to get off the ground. Here is what I have tried so far:

    Using Access' External Data tab, I clicked the More drop down list and selected Outlook Folder. In the Get External Data- Outlook Folder window, I selected "Link to the data source by creating a linked table" I tried 3 approaches in the Link Exchange/Outlook Wizard that both produced undesirable results:
    1) Selecting Address Books>Outlook Address Book>Contacts creates a table that produces the following error when attempting to enter data in Access:
    "You do not have the necessary permissions to use the <name> object. Have your system administrator or the person who created this object establish the appropriate permissions for you. (Error 3033)"
    Outlook Contact entries are not updated to Access
    2) Selecting Address Books>Outlook Address Book creates a table that is not editable in Access
    3) Selecting Personal Folders>Contacts creates a table that is editable in Access but new records in Outlook Contacts folder contain phone numbers, etc. but no first and last name. When double click a contact, it fires up a new untitled e-mail message rather than a contacts data entry window. However, new contacts entered into Outlook appear in Access. Edits in Access to First Name or Last Name fields do not appear updated in the corresponding fields in Outlook but they do appear in the File as: field and are updated into Outlook's First Name and Last Name field once additional edits are made in Outlook... Go figure?

    Anyone out there have any suggestions how to successfully link Access to Outlook so that updates are available at either end?

    I am running on Vista Ultimate SP1; Both Outlook and Access are installed on 2nd physical hard disk (D. Database is installed on C: drive in a folder registered with Access as a Trusted Location.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Linking Outlook contacts to Access database (2007 SP1)

    I don't have Office 2007 or Vista, but I can confirm that editing contacts in a linked table is problematic in Outlook 2002 on Windows XP too.
    I think you should do all the editing in Outlook, and use the linked Contacts table in Access as a read-only view.

  3. #3
    Lounger
    Join Date
    Sep 2006
    Location
    Jhongli, Taiwan
    Posts
    42
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Linking Outlook contacts to Access database (2007 SP1)

    Thanks Hans for taking a look anyway.

  4. #4
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Vancouver, Br. Columbia, Canada
    Posts
    632
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Linking Outlook contacts to Access database (2007 SP1)

    My *guess* is that you will need to decide for yourself which of the contact list is the master, and do all your editing in that location. Otherwise, consider the case where you edit the same record in both locations -- how will the system know which one is correct? If you want to know how complicated *that* gets, look into Access replication... As Hans suggested, you should do all your editing in Outlook.

    Since Outlook provides a programming interface, you could probably write a customized solution that allows edits in both locations, but you would be faced with manually managing the conflicts between edits done in two locations. Not a trivial undertaking.

    My <img src=/S/2cents.gif border=0 alt=2cents width=15 height=15>
    --------------------------------------------------
    Jack MacDonald
    Vancouver, Canada

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •