Hi,

Ok this is a weird one. I have used the automated link table in Access to connect to the contacts folder in Outlook. Both of these being 2007v

Originally this seemed to all work fine and i could see all the data. Now however i am having a problem where i can see all of the data apart from the email addresses. These are input in outlook and they are the correct field names - in fact they have shown up but when i though i had cracked it and saved and closed the db, when i reopened they had disappeared again.

I can work out whether this is a bug or a security setting. Any ideas?

Thanks

i have managed to narrow this down a bit more.

When you open the db with Access 2003, the link table works fine and email addresses are visible. You can then reopen it with Access 2007 and they still show. However if you then close and reopen again with 2007 they disappear.

It therefore seems to be a bug with 2007. Has anyone else noticed this and/or know of any fix?

Thanks