Community

• Blogs
  • Expert Blogs
  • Community Blogs
  • Create a Blog Entry
• Discussions
  • Start a Discussion
• Job Center
• Chapters

User Profile List in SharePoint 2010

• 
• 
• 
• 

The User Information List is a list of every user that has ever been to your site collection or that has been added as an individual user. You may want to use this list for your own purposes. One of the ways you can do this is via Access. The steps to link to it are below.

Connecting to the SharePoint List from Access 2010

1. Open up your Access database.
2. Click on the External Data tab.
3. Click on More and then SharePoint List as shown below
   
4. Enter the top level site collection (i.e. http://howardcentral)
5. Click on Link to the data source by creating a linked table.
6. Click Next.
7. Select UserInfo from the lists of lists as shown below.
   
8. Click OK.
9. You will now have a list of all the users that have been to your site (or that have been added individually).

You will now be able to use a list of users (and a host of other information) so that you can do things like create a phone book to be printed out. Old school, but you would be amazed at how often this request comes up and Access is an amazing tool for creating good looking reports.

Comments

Submitted by Thomas Resing November 22, 2010 - 11:17 AM

I bet that makes a great phone book report! Great idea, Michael.

Report

Was this helpful? Yes No

Reply

Subject  

Comment  

This post and comment(s) reflect the personal perspectives of community members, and not necessarily those of their employers or of AIIM International