- May 2013 (2)
- April 2013 (3)
- February 2013 (2)
- January 2013 (1)
- December 2012 (3)
- November 2012 (2)
- August 2012 (1)
- July 2012 (9)
- May 2012 (6)
- April 2012 (1)
- March 2012 (3)
- January 2012 (1)
- December 2011 (3)
- November 2011 (1)
- October 2011 (2)
- September 2011 (3)
- August 2011 (1)
- July 2011 (2)
- April 2011 (2)
- March 2011 (3)
- February 2011 (2)
- January 2011 (1)
- November 2010 (2)
- October 2010 (10)
- September 2010 (12)
- August 2010 (5)
TagsAccess 15 Access 2007 Access 2010 Access 2013 Access on the Web Access Services 2013 Android blackberry compatibility firefox iPad iphone Microsoft mobile Office 15 Office 365 Office 2010 playbook press release printing help promotion RDP hosting Remote Desktop remote desktop hosting sale sharepoint 2010 sharepoint 2013 sharepoint feature SQL Server 2012 tablets Training virtual appliance
We have been getting tons of requests from Access developers and DBAs about SQL Server 2012 (previously known as “Denali”) that need multiple databases and other more robust SQL 2012 options. Today we are pleased to announce the availability of Microsoft SQL Server 2012 Web Edition for $199/month.
This is the latest installment of Microsoft’s popular database and it includes a number of improvements over previous versions. New improvements SQL 2012 include AlwaysOn for higher availability, Contained Databases to improve on some of the authentication challenges associated with moving databases and FileTables for those apps that manage unstructured data that lives as files outside of the database.
Of course the big advantage of this plan to Access Developers is the ability to create an unlimited number of tables, databases and SQL user logins so that you can manage multiple clients, databases, projects and Access applications from the same secure cloud-based location. If you have any further questions, please check out our SQL 2012 webpage and feel free to chat online with a sales representative or contact us via email.
Access 2013 requires the SQL 2012 Native Client in order to run reports against a 2013 web application that has been published to SQL 2012.
You can download the 32 and 64 bit version of those files here.
This first video demonstrates how to Add Users to Your SharePoint 2013 Site Collection with SharePoint Designer 2013
This tutorial shows you how to Add Users to Your SharePoint 2013 Site Collection via the browser
here is the Access 2013 Quick Start Guide with tutorials for MS Access 2013:
As part of the January 2013 patch cycle Microsoft has introduced an update for Access 2013. You can use Windows Update or direct download to update your system and both 32 and 64 bit verisons are available. What does this patch accomplish ? The KB article alludes to to “stability and performance improvements” without any additional details.
Here is a screenshot of an unpatched system:
And after the patch is applied:
One of the most important changes with Access 2013 and their new web apps is in the architecture itself.
In SharePoint 2010, Access Web Services was storing everything in SharePoint (and then SharePoint’s content was backed up by SQL). Access 2013 apps are hosted by SharePoint 2013 while the data is stored in SQL Server 2012. SharePoint 2013 provides authentication, authorization, and security for Access 2013 apps. The back-end tables, views, macros, and queries are stored in an SQL Server 2012 database. This change in architecture reflects a substantial change in the way Access Services works.
You will notice that SQL stores tables, views, macros and queries but there’s no mention about reporting. That is because Access 2013 Web Apps do not allow you to create traditional Access reports. The only way to do reporting is by connecting the local Access software program to the SQL tables directly or using some other compatible reporting software tool.
There are a lot of advantages of using Access 2013 with SharePoint 2013, but it is important for Access Developer to note the following:
- The idea of the Hybrid Application, SQL reporting services in a browser, and the architecture of Access Web Services 2010 has been completely abandoned by Microsoft. Access Applications can be either SharePoint 2013 web apps OR traditional local Access Applications.
- Any existing SharePoint 2010 web application cannot be moved to SharePoint 2013. You can preserver your tables, but all of your forms, reports, and queries will be lost in the transition from SharePoint 2010 to SharePoint 2013.
- Access 2013 introduces a new application type that enables you to create a web-based Access app in SharePoint 2013. It is easier and more stable than 2010 since it is directly backed by SQL, but there are no built-in reporting services for Access web apps.
- Access 2013 and Access 2010 can both publish to SharePoint 2010 and the old Access Web Services 2010. You must have Access 2013 to publish to SharePoint 2013 and create an Access 2013 web app.
- VBA code is not compatible with SharePoint 2010 or SharePoint 2013 Access applications.
Access Hosting is committed to supporting the Access Developer community and will continue to offer SharePoint 2010 Access Web Services hosting for as long as developers are interested. SharePoint 2013 Access Web apps do have a ton of advantages, and we have launched our brand new Access 2013 SharePoint 2013 hosting packages. If you are interested in a free trial, please sign-up here.
We don’t just offer SharePoint hosting either. We have great ways for every Access Developer and Access application to be hosted in the cloud whether it’s through SharePoint, SQL Server or our RDP solution which lets you host any Access 2007, 2010 or 2013 application without ANY modifications. It supports VBA code too.
Start the new year by reviewing the dramatic improvements to Access and Access Services in SharePoint 2013. This 8 page document will step you through some of the biggest differences between Access 2013 and Access 2010.
What’s New In Access 2013
If you like what you see go ahead and sign up for a free trial of our Hosted Access Services 2013, Remote Desktop 2013, or SQL 2012 solutions.
Here is a short video that shows how to configure Internet Explorer so that hosted Access Web Databases do not require multiple logons to the SharePoint 2013 site collection. If you are getting repeated requests to logon to your SharePoint 2013 site while working with Access 2013 this video is for you.