Friday, September 18, 2015

Access App - SharePoint 2013

  1. Access app can be created within Office 2013 client and pointing to Office 365 or On-Premise site collection 
  1. Can be use two way of authorization (app only permission , app+user permission). 
  1. Can leverage the multi authentication including the OAuth. 
  1. Access App can be created from data sources like SQL , Web Service, Excel and flat files (.txt & CSV) 
  1. App can be saved as "Snapshot" including with data , in order to move the app around all the site collections and tenants. 
  1. Supports the Form kind of operation and compatible with all devices. 
  1. Clear navigation path and multiple app templates available for Look and Feel good. 
  1. Support the Reporting , sorting and filter. 
  1. Can be editable in the Grid View Format (as seen in SharePoint 2013 List) 
  1. Can be used to run the old Access database with all Macro features that gives the business logic implementation. 
  1. built-in search functionalities to search the huge records. 


  1. Office WebApp must have installed in all WFEs and involved licensing model. 
  1. No option to trigger the SharePoint Workflow or Item level permission. 
  1. Must have SQL 2012 Enterprise edition installed as Access App uses the SQL table behind the scene. 
  1. Access 2010 and Access 2013 app services must be up and running on the Server, Access 2010 services also required for backward compatibilities. 
  1. SharePoint App configuration (DNS Set up) must be installed and configured on the Server as Access App model relies on the SharePoint App mechanism. 
  1. Often crash as it requires relies on the installed Office Web App in SharePoint server. 
  1. Must have the dedicated Site collection for Access app to manage identical app.