Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

I am connecting to Sharepoint through MS Access 2003 and the lists are displayed in Access as linked tables. Everything is fine till here. The list when accessed in Sharepoint site (in browser) shows the name of the project owner e.g.LastName, FirstName but the same field is not shown when the linked Sharepoint list is viewed in Access. The data type of that field in sharepoint is Person and looks up the name through Active Directory.

I am looking for some more info on why the name field does not show up in Access linked table?

share|improve this question
add comment

migrated from stackoverflow.com Oct 11 '12 at 13:28

This question came from our site for professional and enthusiast programmers.

1 Answer

You might try creating a new query off your linked table and you should see all fields available. For some reason the table view leaves out a lot of fields, probably due to a property setting on the field.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.