No parlor tricks here – just the Microsoft Remote Desktop App connecting to hosted remote desktops running the last 4 (count em FOUR) major releases of MS Access. This allows most applications to run unmodified in the cloud using the version of Access they were originally developed in. Take Access anywhere using any device without the hassle and expense of application rewrites.
By combining a remote desktop Access frontend with a SQL Server on the same high speed switching fabric you get the best of both worlds: A secure, scalable database application combined with the ease of Microsoft Access on any device.
Here is a video overview of the Microsoft SQL Server Migration Assistant in action.
Your Remote instance of Access can now be paired with SQL Server over our high speed network switching fabric, eliminating the traditional latency of a web based SQL backed.
In many cases the migration assistant can be used effectively without outside assistance – but if you require a helping hand we can recommend qualified Access and SQL Server experts that can assist for a reasonable one time fee.
Breaking News: You no longer need to purchase third party software to connect your Mac, iPhone, iPad, and Android devices to our Remote Desktop Hosting Service . You can now run the Access Runtime (2010 or 2013), Access 2007, Access 2010 (32 and 64 bit) and Access 2013 (32 and 64 bit) on all these devices with a FREE app. Wow.
We recently updated our popular YouTube video that shows Access running inside the Safari and Chrome browsers on the iPad with iOS7. This new and improved solution requires no extra software and allows Access 2007, 2010 and 2013 applications to run without modification.
Microsoft Office 365 provides anywhere access to your familiar Office applications, email, calendar, video conferencing, and most up-to-date documents, across your devices – from PCs to smartphones to tablets. Choose to run it the way you want with enterprise-grade security, IT controls and flexible deployment options that let you run it on-premises, as a hosted service or as a hybrid of both.
However, even an enterprise-class productivity and hosting solution like Office 365 will not fully meet the Access web database needs of all customers. An On Premise or 3rd Party Hosted Access Services 2013 implementation helps provide focused, reliable solutions for the following common customer needs:
1. Full control of SQL Server security: Access 2013 allows for the automatic creation of 2 SQL Server user accounts, one with read-only privileges and another with read-write. While that is useful, some customers would like to extend this model to multiple user accounts. By creating multiple SQL logins via SQL Server Management Studio (SSMS) you can create a much more complex security model for applications that want to leverage the Access 2013 web database information stored in SQL Server. Password complexity and aging requirements can also be enforced on these accounts.
2. Full control of the network firewall: Many Access 2013 applications require extended security to comply with corporate or regulatory requirements. The Health Insurance Portability and Accountability Act (HIPPA) security requirements are a good example of this necessity. In a self-hosted or 3rd party hosted solution you have enough firewall configuration flexibility to lock down your entire database by imposing restrictions on the network perimeter based on TCP/IP address ranges, machine names, and network protocols. A combination of these restrictions can be imposed to address any security mandate.
3. Render http links in the web browser control of an Access 2013 web database: The browser control is a powerful feature in Access 2013 web forms that allows you to call external resources into your application. Office 365 requires https for all external links which limits the use of browser based resources that do not support https. This restriction can be lifted in a self-hosted or 3rd party hosted configuration.
4. Customized backup: You can create a backup rotation scheme in SQL 2012 for the Access Web Apps that mirrors the site collection backup routine in SharePoint. This allows for a synchronized full fidelity backup of the SharePoint site and the Web Apps with multiple restore points. We recently assisted a customer who required a complete snapshot of their SharePoint and Access Services environment to be available for rollback to 24/47/72/96 hour recovery points. In addition, the second and fourth snapshots needed to be available in a secondary data center in the event of a problem with the primary facility. All of this is easily accomplished in a hosted configuration where both the SharePoint and SQL Server environments are completely controlled by the hosting organization.
AccessHosting.Com offers a unique, low cost, and scalable approach to getting your Access database into the cloud. Our entry level price point is just $19 month for a remote desktop session that allows a single user to run their Access 2007, 2010 or 2013 database without modification, and includes the rich feature set that Access developers are comfortable using and maintaining. Don’t be confused by the marketing hype surrounding Access Services and SharePoint in Office 365 – those solutions require significant conversion effort and a substantially reduced feature set to run Access forms, queries and reports in the browser. Our simple approach lets you take your existing database from the desktop intact with forms, rich reports, VBA code, and legacy macros and run it from any device that supports a remote desktop connection. That includes iPads, Kindle Fire, Surface Tablets and many other popular devices.
An Inexpensive Solution
With the Access Runtime environment you do not need a copy of Access for you users – only the developers of the applications. Without this requirement the cost of running your application remotely can be as little as $19/month per user. Additional users can be installed at any time to share a common backend database that is secured on the same remote desktop, offering a high performance solution to multi-user connectivity.
A Scalable Solution
Sometimes Access databases grow up to be very big – and performance suffers. We offer an easy way to take your traditional Access data file and convert it to a hosted SQL Server solution on our same network switching fabric, giving you a high speed connection to a scalable backend that will not impact performance as the size of your database grows.
How Do I ?
We understand that you sometimes need step by step guidance to perform a specific task. To that end we have produced many instructional videos to help you get started with our solution. Everything from moving your database form the desktop to the remote desktop, setting up local printing, and securing multiple users on your database is covered in detail in these tutorials.
Want To Learn More?
We are convinced that this is a great way for people to run Microsoft Access on the Web – but don’t take our word for it. You can test out solution obligation free for 30 days. There are no long term contracts or the “lock-in” typically found with QuickBase, Caspio, and other web database solutions. If the product does not meet your needs you will not be charged – simple as that.
The Microsoft Access 2013 runtime has been released.
The wait is over for Access 2013 Runtime. Here are the download links for the last 3 versions of the MS Access Runtime environment. Remember that you can use these runtime packages to deploy Access Applications free of charge. They make a great low cost solution for putting legacy Access applications on the internet, the iPad, and most Android devices WITHOUT the hassle and expense of conversion using our Remote Desktop Hosting and SQL 2012 Hosting Plans.
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.
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.
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.