1 / 23

An Old Dog Learns Some New Tricks

An Old Dog Learns Some New Tricks. Welcome to Access Services 2013 ! Noah Spannbauer Developer Magenic Delivery Center. New Blog: http://www.magenic.com/blog Old Blog: http://www.magenic.com/blogarchive. Agenda. Access Services Overview Why should we care about Access Services ?

liesel
Download Presentation

An Old Dog Learns Some New Tricks

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. An Old Dog Learns Some New Tricks Welcome to Access Services 2013! Noah Spannbauer Developer Magenic Delivery Center

  2. New Blog: http://www.magenic.com/blog Old Blog: http://www.magenic.com/blogarchive

  3. Agenda • Access Services Overview • Why should we care about Access Services? • What is Access Services? • Architecture • Who will use Access Services? • Configuring Access Services • Creating a New Access Web App • Demo • Managing Connections • “Hybrid” Access App • Q & A

  4. Why should we care about Access Services? Tables are now centralized in an instance of SQL Server 2012 Access desktop applications are everywhere Access apps are SharePoint apps accessible from any browser Not easy to share an application with other users App inherits the parent site’s permissions Security is challenging Full backup and restore capabilities of SQL Server 2012 Poor backup practices

  5. What is Access Services?

  6. Architecture SharePoint Web Browser Access Services Consumes SQL DB Tables & Data Access Client 2012+ Creates

  7. Who will use Access Services? Pro Dev Power User Apps for SharePoint Apps for Office Access Services 2013 The easiest way for a non-developer to build and publish apps for SharePoint “Napa” Office 365 Development Tools A lightweight, in-browser development experience Visual Studio A great end-to-end development experience for highest customization

  8. Configuring Access Services • Prerequisites • SharePoint 2013 on Windows Server 2008 R2 or higher • SQL Server 2012 Standard or Enterprise edition • SQL Server 2012 Feature Pack • App Management Service • DNS Configured for SharePoint Apps • Secure Store Service – Security Service key Generated • Subscription Settings Service

  9. Configuring Access Services • Configure SQL Server 2012 for Access Services • Set the SQL Server Security Mode • Set the SQL Server Enable Contained Databases Property • Set the SQL Server Allow Triggers to Fire Others Property • Set the SQL Server Default Language Property • Configure SQL Server Protocols • Configure Windows Firewall Settings for SQL Server 2012 • IIS Application Pool Load User Profile Setting • Configure Access Services • Start Access Services on the Server • Create Access Services Service Application • Complete Additional Permissions Settings, if Necessary

  10. Configuring Access Services • Configuration guides • White Paper: Office 2013 – Access Services Setup for an On-Premises Installation - http://www.microsoft.com/en-us/download/details.aspx?id=30445 • Kirk Evans Blog - Additional Permissions Settings - http://blogs.msdn.com/b/kaevans/archive/2013/07/14/access-services-2013-setup-for-an-on-premises-installation.aspx

  11. Create a New Access Web App • From SharePoint

  12. Create a New Access Web Page • From Access 2013

  13. Demo

  14. Managing Connections

  15. Managing Connections

  16. “Hybrid” Access App Access Services 2013 Access 2003 Forms Macros Reports Queries Forms Macros Reports Queries Import Tables SQL Tables Tables Linked Tables

  17. Hybrid Access App • Create a new Access Web App • Import Access Desktop App tables into the web app • Enable Read-Write Connection • Delete the Access Desktop App tables • Use Read-Write Connection Information to connect to the SQL database from the Access Desktop App • Link to the tables in SQL Server • Recreate relationships if necessary

  18. References • Books • First 8 chapters devoted to Access Web Apps • Lots of sample files • Easy read

  19. References • SharePoint Conference 2014 sessions • Access is back! High-value, 'no code', functional & flexible business apps with the new Access services - http://channel9.msdn.com/Events/SharePoint-Conference/2014/SPC301 • Anyone can build a SharePoint App with Microsoft Access - http://channel9.msdn.com/Events/SharePoint-Conference/2014/SPC204 • No-code SharePoint 2013 Solutions for power users - http://channel9.msdn.com/Events/SharePoint-Conference/2014/SPC285

  20. Questions?

  21. Thank you for attending! Noah Spannbauer Developer, Magenic Delivery Center noahs@magenic.com Download today’s presentation and sample Access app at: http://magenic.com/spstc

More Related