Unless you’re an Access developer, you’ve probably never used the Access Runtime before. Since our basic RDP hosting plan comes with only the runtime, we get a lot of questions about what the runtime is and how it is different from the version of Access on their computer and which remote desktop hosting plan would work best for their Access database. Hopefully, this post will help steer you in the right direction.
What is the Access Runtime?
Microsoft describes the runtime as such, “The Microsoft Access Runtime enables you to distribute Access applications to users who do not have the full version of Access 2013 installed on their computers.” It’s a free download from Microsoft as opposed to part of the expensive Office Professional suit that includes the full and powerful version of Access that Access developers have installed on their desktops. It’s the equivalent of Adobe Reader – it lets you open PDFs and is free, but lacks many of the features found in Adobe Acrobat. If you want to do anything of meaning in Access or if you’re an Access developer, you want the paid, full version of the program. The runtime is intended to be used with already designed databases so data-entry and other users can simply open your database file and interact with your forms and access application.
I still don’t get it
Let’s take a closer look at the famous Northwind Traders database in the Access 2013 runtime and the full version of Access.
As you can see this complex database easily opens in the Access Runtime and gives you access to everything that was designed in the Access App: create new customers, view invoices, etc. But you’ll notice that there is no Access ribbon and you cannot use the navigation and or see the database structure and design. There are really no tools beyond what is built within the database. I’m sure you can see the advantage of this type of security for Access developers. The Access Runtime makes it impossible for a user to alter their application and they can even have limited access to the database and records themselves.
Here is the same database in the full version of Access 2013. I have access to all of the tools in the ribbon. I can create new forms, queries, reports or view the tables and records directly using the left sidebar navigation menu. None of these features are available in the Access runtime.
The Access runtime only really has one menu that is included in every database – the file menu.
All this menu really lets you do is print the forms and reports that you are able to access in the secure stripped down version of the already developed Access database application. Conversely, the full version of Access lets you create new databases, edit and save databases, print and much more from it’s file menu:
Hopefully this has helped you figure out what the Runtime is all about. If the limited nature of the runtime works for you, then our $19 RDP hosting plan should work for you and your already developed Access database. If you are more comfortable with the full paid version of Access installed on your computer, then you will want to go with our $29/month remote desktop hosting plan.