Where are fields stored ?

[mray29]

After creating a helpdesk form, I added an Assigned To combo box and tied it
to a custom field. It works OK in Outlook, but when I link to the folder
throgh an Access ODBC connection to Outlook that field doesn't appear to be
in the table. Any ideas where it's being stored?

 

[Sue Mosher [MVP-Outlook]]

Fields, aka properties, are stored in the individual Outlook items. The linked table method of exposing an Outlook folder in Access has major limitations, however, including the inability to show even all the reasonably important standard fields, not to mention any custom 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/article.aspx?ID=25 .

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.