SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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

migrated from Oct 11 '12 at 13:28

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

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

Your Answer


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