SharePoint 2013 – Building an Access app

SharePoint Server 2013 offers following two methods of creating end-to-end business solutions that are webbased. Both the methods require purchase of MS SharePoint Server Enterprise Client Access Licenses (also called CALs).

Access Web Database

You cannot create these using Access 2013. You can view & edit a web database that has been previously created by making use of Access 2010 as well as SharePoint Server 2010. You can also use Access 2010 to republish it to SharePoint Server 2013.

Data that is held in Access tables is smoothly moved to MS SharePoint lists, and forms & reports are created in form of webpages. You cannot convert a web database straight away to an Access web app. However, you can always convert a web database to Access web app. This can be done by importing the data available in web database straight into a new Access app. Further, you need to re-create the user interface as well as the business logic.

Access Apps

These basically are SharePoint apps and so can be deployed easily to the SharePoint Store. While you make use of the browser to view & edit data; you can use Access 2013 for designing the Access app. Data & Access objects for every single Access app gets saved in its own SQL Server 2012 database. The same is never saved in SharePoint lists. Such SQLintegrated approach considerably improves the performance, scalability and manageability of the business solution.

Techarex Networks SharePoint Hosting Solutions provides a best-fit collaborative environment,fetching maximum ROI with our world-class SharePoint hosting plans. Our customized deployment helps you to select business-centric configuration. Experience industry-leading SLAs and dedicated 24X7 support, augmenting business needs with world-class industry-ready SharePoint foundation, enterprise, and custom hosting plans.