Missing data in MS Access 2007

[Moxy1]

i'm connecting to a document library to run some comparison reports through Access 2007. The problem that I've run in to is that there are a couple fields that are pulling in to the database without any values.

When compared to the SharePoint view I'm able to verify that data does exist for the field in question. If I pull the same view in to an Access 2003 database the data is there as expected.

 

[ehaze]

what is the SharePoint field type that is missing in Access 07?

http://www.sharepointed.com/

 

[Jowidog]

The reason ehaze is asking about field types is that MS Access does NOT like multi-value fields from external datasources for example if one of your fields in SP is an attachments type field, it does not translate well or come across unless you modify the way Access can handle the field exception types.