Results 1 to 2 of 2
  1. #1
    is49460 is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Jan 2010

    Sharepoint Lists vs Web database as backend


    Any suggestions about advantages and disadvantages of creating Sharepoinit Lists as a back-end for Access 2010 front-end versus having a web database on sharepoint as a back-end. I have different front ends using the same data, so I can't just make a single web database. Any input is appreciated, thanks!

  2. #2
    NTC is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    Nov 2009
    if you are using web forms - then you must use a web database; and so that answers the question.

    if you are using traditional Access client FEs and everyone is on the same LAN - then I would stay with Access BE - and only rely on sharepoint to serve a classical file server role and do neither sharepoint lists nor web database - or not even use sharepoint at all.

    if you are using traditional Access client FEs and everyone is NOT on the same LAN, where there is a WAN involved - and you will be using the 'Work Local' feature that moves the BE data then I think you will want to use sharepoint lists. But now that you ask the question I am not 100%. Web database offers back end triggers. But I doubt they are as feature rich as your classic VB capable Access FE and so I guess one would stick with lists.....good question.

    hope this helps.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Access lists
    By michaelcoomes in forum Access
    Replies: 1
    Last Post: 11-04-2010, 11:18 AM
  2. Username For Sharepoint
    By is49460 in forum SharePoint
    Replies: 0
    Last Post: 10-08-2010, 05:40 PM
  3. SharePoint and Access 2010
    By ksmith in forum SharePoint
    Replies: 4
    Last Post: 08-24-2010, 09:19 AM
  4. Lists not showing all columns?
    By HMEpartsmanager in forum Forms
    Replies: 6
    Last Post: 11-18-2009, 03:39 PM
  5. Access lists? Help!!!
    By megank in forum Access
    Replies: 1
    Last Post: 03-15-2009, 04:11 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
Other Forums: Microsoft Office Forums