Update Outlook Contacts from Access

How did you create that linked table to contacts?

Pat,  
Testing this, I'm experiencing the same thing in Office 2010 with an Outlook account... and am wondering if it is not a bug, or an incompletely developed feature.  It looks like permissions are set properly on my Outlook files.  I've seen no examples online of people actually updating linked contact tables, but would think that if the data is read-only (like linked Excel sheets) that the error message would be more intuitive.

Miriam, thanks.  I was thinking the same thing. I'll look into ole automation but so far haven't found a useful example.  When I have to automate Excel, I can just go into Excel and start the macro recorder.  That usually gets me most of what I need.

How did you create that linked table to contacts?

the same way I would link to any other new data source - External Data/New Data Source.  Is there some other way that I don't know about?

Pat,

I'm not sure if this question will automatically delete without a comment or not.  Anyhow please keep it open a bit longer.  I just sent out an email today to see if the Access team could provide more insight.

Thanks.  I got sidetracked and ended up entering the most important contacts manually.  But since I now know that Outlook does not provide a way to backup contacts, calendar, and rules automatically - (be very careful people if you are using IMAP rather than POP.  You could end up loosing everything except your actual email unless you are willing to pay for a third party tool that can recover some but not all of it.), I'm hoping I can use Access to plug the hole.  I can create a database that backs stuff up a couple times per week.  But so far the recovery is eluding me.  Except for occasionally having to automate Word and Excel, Outlook is really the only reason I pay for Office.  Now that I know I can not rely on it anymore, I will probably end up buying Access and switching to open office for the the stuff I currently use Office for.  I have always hated web mail interfaces which is why I stuck with Outlook.