Linking a SharePoint List to MS (How-To)

Standard
  1. Open up the MS Access Database that you want to link the data too (Or create it) and go to the SharePoint list that you want linked.
  2. In your MS Access database, go up to the ribbon and click External Data > More (Under Import & Link) > SharePoint Lists.
  3. Copy & Paste in the base site URL for your list. Note: Once you start doing this, your sites will be remembered for future use. For example, my list is seen in the next example image.
  4. Then below that, select the option of how you’d like to link it. You can 1. Import data (not link) or 2. Link Data. We’re going to Choose the second for this example, but it’s important to know you don’t have to. Then click Next.
  5. The next screen will show your lists. Click the ones you want linked. Note, regardless if you select User Info, it will link it. That’ll be explained at a further blog post. Click OK.
  6. You’re finished! On your left MS Access Nav you should see your newly linked List. 

Note:

  • You are now free to treat it like any other database object (except you can’t edit the columns and fields within Access, you must do that via SharePoint.
  • If you do change the list, you may need to unlink it & relink it for it to work properly.

 

Double Data Entry – MS Access and SharePoint

Standard

So recently at work someone had been asking if SharePoint is able to become usable for data entry from both MS Access and SharePoint. One of his reasons was that they are scattered across the nation and accessing a shared drive Access database is not a good use of bandwidth. I’ve done a few things extensively with SharePoint where I append data INTO SharePoint, where I’ve extracted Data FROM SharePoint but I hadn’t really tried using a live list where I could manage my data living ON a list from both Access and SharePoint. Continue reading