ACCESS-OUTLOOK-CONNECTION

[Gerard Treur]

Hello,

In Outlook I have created a table which is connected with Outlook.
So I can use the adress-data from my outlook-contacts in a database.
The number of datafields is unfortunately limited and I want to add extra
userfields.

Can someone help my out with this problem?

Thanks!


Gerard

 

[Sue Mosher [MVP]]

The linked table method has major limitations, including the inability to show even all the reasonably important 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. See http://www.slipstick.com/dev/database.htm#linkedtables .

That page will also give you other ideas on how to work with databases and Outlook together.

--
Sue Mosher, Outlook MVP
Outlook and Exchange solutions at http://www.slipstick.com
Author of
Microsoft Outlook Programming: Jumpstart
for Administrators, Power Users, and Developers
http://www.slipstick.com/books/jumpstart.htm

 

[Gerard Treur]

Thank you for your message explaining that linking table method is not possible.

I've read the articles you suggested.

There is however one method to add columms (I found out by accident)

When I create a linked table in Access, the system write an ini-file to my harddisk.

This file (schema.ini) is located at C:\Documents and Settings\<username>\Local Settings\Temp.

In this file the linked columns are named (defined?).

I added an extra column <test> in schema.ini and create in Outlook

an user-field <test> and placed this user-field onto my custom contactform.

After this I linked the table in Access.

The data I entered in the userfield on my custom contactform in Outlook appears

in the column <test> in the linked table in Access.

Also, I tried to add extra columns with names of the standard Outlook fields.

However the data failed to show up the data in the linked Access table.

I am just an amateur-developer but maybe this method will trigger an idea by more experienced developers.

Let me know!

Gerard Treur

"Sue Mosher [MVP]" <[email protected]> schreef in bericht The linked table method has major limitations, including the inability to show even all the reasonably important 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. See http://www.slipstick.com/dev/database.htm#linkedtables .

That page will also give you other ideas on how to work with databases and Outlook together.

--
Sue Mosher, Outlook MVP
Outlook and Exchange solutions at http://www.slipstick.com
Author of
Microsoft Outlook Programming: Jumpstart
for Administrators, Power Users, and Developers
http://www.slipstick.com/books/jumpstart.htm