Access Services empowers users to solve business needs without engaging IT resources Access Services allows IT to monitor databases across the organization through.
Download ReportTranscript Access Services empowers users to solve business needs without engaging IT resources Access Services allows IT to monitor databases across the organization through.
Access Services empowers users to solve business needs without engaging IT resources Access Services allows IT to monitor databases across the organization through the power and flexibility of SharePoint 2010 Access Services is built to scale on SharePoint More Demands Fewer Resources http://www.mysite.com/MyApplication/ MyApplication.accdb ACCDB SharePoint Site (SubWeb) Tables Lists Publish System Table msysaso ASPX Pages Client Objects Roundtrip! Yes that includes VBA and Link Tables Workflows SQL Reports JavaScript Browser WFE Get http://server/MyForm.aspx Pick an ADS box using health info ADS OpenResultSet(“Customers”, 100) New workbook Run Query Render Data Return HTML and Session ID to browser Return first 100 rows and session ID Store data In-memory Content DB Browser WFE http://server/AccessPortal.asmx?GetData SessionID=##### StartRow=101 RowCount=100 Apply data to HTML DOM ADS Crack session ID and figure out ADS box GetData(101, 100) Pull rows out of inmemory data table Return 100 rows Return data to browser Content DB • List Relationships (Restrict Insert, Cascade Delete) • Unique Column Constraints • Data Level Validation • Data Macros Browser Access client Client Form & reports Server Datasheet Data Form Web Part Project JS object Access services session Access services Web service ADO.Net In-memory Query processor Data access layer Expressions Validation Referential integrity WSS Lists Access services event handlers WorkFlows QuickFlows Browser Web Farm WFE 1 WFE 2 Data View Web Part Access services AJAX WS WFE 3 Data View Web Part DSC Access services AJAX WS DSC Load balancer + proxy Data View Web Part Access services AJAX WS DSC Load balancer + proxy ADS/RS1 Load balancer + proxy ADS/RS2 ADS Web service (private) Data table cache ADS Web service (private) Query Processor Data table cache SharePoint OM Content DB Query processor SharePoint OM Browser Web Farm WFE 1 Data View Web Part Access services AJAX WS … Report Viewer Web Part DSC Load balancer + proxy Hardware Load Balancer ADS/RS1 ADS web service (Private) Report Server … Query processor Access data provider SharePoint OM Report DB Content DB | blogs.msdn.com/access | channel9.msdn.com/shows/access www.microsoft.com/teched www.microsoft.com/learning http://microsoft.com/technet http://microsoft.com/msdn Play the Microsoft Office & SharePoint Track Tag Contest Download the Microsoft Tag Reader Open the internet browser on your mobile phone and visit http://gettag.mobi Grand Prize (1) Xbox 360 Prize Package and Microsoft® Office 2010 Daily Prizes 40 copies of Microsoft® Office 2010 Come to the Expo Hall – Yellow Section OSP Info Desk for Official Rules & Collect Additional Tags from all OSP Track Sessions, Speakers and Expo Hall!