FileAs field in Outlook 2K3 - Access Linked Tables

[Jeff Briar-Hill]

I use access linked tables to get contact information from outlook. i
use the "fileas" field as the key for joining against other databases
(quickbooks for example)

everything worked great in outlook xp.

i just upgraded to outlook 2k3 and encountered a problem. the fileas
field is no longer one of the fields that access pulls in when you do
a linked table to your contacts. as such, i cannot run the joins
anymore.

does anyone know if there is a way to customize outlook to specify
which fields will be published to the access linked table manager?

thank you.

 

[Sue Mosher [MVP-Outlook]]

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.outlookcode.com/d/database.htm#linkedtables .

That page will also give you other ideas on how to work with databases and
Outlook together. You'll need to write code or use a third-party tool that
does the heavy lifting.