Hello,
I am trying to link my Access database to Outlook. I followed the link
wizard and created a linked table in my Access database. I tried to create an
update query to update the mail table, but got a message box stating zero
records will be updated. I did some reading and found that I have to have a
field in the mail table that I can link to the main contacts table in my
database.
I have in my database main table a primary field "ContactID" which is an
autonumber. I need to have a field in my contacts list which is a number
field that I can use to make a relationship with the tables.

Can someone please describe to me How I can add a field in my outlook
contacts lists that will show up in a table when it is created that I can use
to make a relationship. Nothing I have tried in the help section lets me
create that field I need and have it show up in the contacts data table.
Thanks

The linked table method has major limitations, including the inability to show even all the reasonably important fields, much less custom Outlook fields. While articles have been written on how to expand on this method's obvious features, I've never been able to duplicate the results. But if you want to give it a try, see http://www.outlookcode.com/d/database.htm#linkedtables .

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003
http://www.turtleflock.com/olconfig/index.htm
and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx


"Bill_De" wrote in message ...
Hello,
I am trying to link my Access database to Outlook. I followed the link
wizard and created a linked table in my Access database. I tried to create an
update query to update the mail table, but got a message box stating zero
records will be updated. I did some reading and found that I have to have a
field in the mail table that I can link to the main contacts table in my
database.
I have in my database main table a primary field "ContactID" which is an
autonumber. I need to have a field in my contacts list which is a number
field that I can use to make a relationship with the tables.

Can someone please describe to me How I can add a field in my outlook
contacts lists that will show up in a table when it is created that I can use
to make a relationship. Nothing I have tried in the help section lets me
create that field I need and have it show up in the contacts data table.
Thanks