By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,131 Members | 1,425 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,131 IT Pros & Developers. It's quick & easy.

Error link to an Outlook Address Book from Access 2007

P: 3
I am running MS Access 2007 and I want to update an Outlook Address book from my Access Database. I started out by importing the Outlook Address Book as a linked table and it linked fine. I then built a query to filter a master contact list of contacts and I made it an append query to added to the linked Outlook address book table. However, I am getting an error message that says I do not have the necessary permissions to use this object.

At first I thought it was my query but I tried to just open the linked table and manual enter a name and fax number and I get the same error. My goal in the end is to be able to load this query data to the Outlook address book and then using the MS Fax print drive fax reports to folks directly from access. The database would keep the Outlook address group updated.

I have attached the actual error message I get when I try to enter data to the link Outlook Address Book:

Is there VB code that will set the permission on a linked outlook table?

Any help on how to set permissions on a linked Outlook address table would be appreciate. I have attached I screenshot of the structure and actual error call. Thanks in advance!

Pat

Linked table name: Prizewinners
Query name: Call-List Filter by Project-Append
Attached Images
File Type: jpg error.jpg (13.0 KB, 186 views)
Dec 1 '07 #1
Share this Question
Share on Google+
1 Reply


puppydogbuddy
Expert 100+
P: 1,923
This is an issue involving the MDW file in MS Access. My understanding is that the system mdw file is no longer used If you convert your database to the new 2007 file format. If you have not migrated to the new format and continue to use the mdb format, then this link tells you what have to do to migrate your system mdw file.


http://office.microsoft.com/en-us/ac...345611033.aspx
Dec 2 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.