Runtime Version
FAQs about deploying Applications built with Microsoft Access using the Access Runtime version.
Starting with Access 2007 the Microsoft Office Access Runtime is available for free from Microsoft. You can find the links to the Microsoft Office Access Runtime downloads in the Deployment and Installers (Click Here) section.
What is the Access Runtime Version?
- Details
- Category: Runtime Version Runtime Version
- Last Updated: 13 September 2020 13 September 2020
I have been using the Access runtime since 1997 when I purchased the Access Developer edition. The Developer edition included a license to distribute the Access runtime. Starting with Access 2007 Microsoft has made the developer extensions and a license to distribute the runtime free.
Access 2007 runtime deployment - FAQs
- Details
- Category: Runtime Version Runtime Version
- Last Updated: 13 September 2020 13 September 2020
Microsoft now makes the Developer Extensions free to anyone who owns a copy of Office 2007 Access. The Access 2007 Runtime is now a free download. If you have never heard of or used the Access runtime version then I recommend reading What is the Access Runtime Version? (Click Here)
The Access 2007 Developer Extensions provide packaging and deployment tools and licensing and distribution agreements to make it easier for developers to bring solutions to market. Whether you are working in a small business or a large enterprise, as a third-party or an internal developer, the Access 2007 Developer Extensions can facilitate the deployment and management of Access 2007 solutions.
Question: Are there any special considerations when using the Access runtime to run my database?
Answer: The Access 2007 Runtime is, in essence, Office Access 2007 with a few key features disabled.
A user who has the Access 2007 Runtime installed instead of the full version of Access can open and run an Access application but cannot see the Navigation Pane or switch the view of any Access object to Design view.
You will need to be sure that provide:
- User Interface: At a minimum, every Access 2007 application destined for an Access Runtime environment must include a user interface object that enables the user to navigate through the application. This object might be a customized Navigation Pane, a custom Office Fluent Ribbon, or a startup form—that is, a form that helps the user navigate through the forms and reports that make up your application.
- Error Handling: It is always good programming practice to handle errors that might occur in VBA code, but when users work with the application in an Access Runtime environment, such error handling becomes crucial. Every procedure in an application should have, at a minimum, a basic On Error GoTo label error handler.
Additional reading:
Basics for Building Access 2007 Runtime-Based Solutions
Summary: Find out how to prepare your application for use with the Microsoft Office Access 2007 Runtime.
How to: Create a Shortcut Menu for a Form, Form Control, or Report
FREE ribbon tools for Access 2007 and 2010
Question: How can I test to be sure that my database is ready for use with the Access 2007 runtime?
Answer: Test your database in runtime mode on your development PC.
Simulating the Access Runtime Environment from Full Access
Access 2007 provides two methods that you can use if you want to see how your application looks and works in an Access Runtime environment.
If you used the .accdb file format for your application, you can simulate the Access Runtime environment by changing its filename extension to .accdr.
Alternatively, you can use the /runtime command-line switch with the full Access executable to simulate the Access Runtime environment. Create a shortcut with a target like the following.
"C:\Program Files\Microsoft Office\OFFICE12\MSACCESS.EXE" /runtime "drive:\path\file_name"
Note The line in this example might have wrapped for printing. However, no line wrapping is supported in command-line switches.
Test your application under the Access Runtime (either by using the command-line switch or by installing it with the Access Runtime on a clean computer) before deploying the application to other users.
Additional reading:
Basics for Building Access 2007 Runtime-Based Solutions
Summary: Find out how to prepare your application for use with the Microsoft Office Access 2007 Runtime.
Question: How do I deploy my Access 2007 application with the Access 2007 runtime included?
Answer: Create a deployment package.
There are several options available.
- Microsoft includes in the Access 2007 Developer Extensions a Packaging Solution Wizard add-in. This is a very basic solution.
- Use a Third-party Installer. There are even some very good free one.
Using a Third-party Installer
Free INNO Setup installer
With this script the initial download is far smaller in size for the end-user that already has Runtime installed. he script has been put together using code snippets found on different forums along with bits I did myself, so thanks go to everyone.
This script will check to see if the user has either Access 2003, AccessRT 2003, Access 2007, or AccessRT 2007 installed.
If no access is detected, it will automatically download your Access 2003 runtime files from your web server and install them before continuing with installing your mde.
If access 2007 is detected, the end-user will be prompted that functionality may differ (This can be changed)
If access 2003 is detected, the installation will continue.
The script will also add the relevant registry entries to eliminate the Security Warnings that normally show up when launching an .mde.
The script for the free INNO Setup installer that can be downloaded from HERE on this site.
Other Products
A very popular commercial product is Sage Key (Click here)
Using the Microsoft Package Solution Wizard add-in.
The Package Solution Wizard is an add-in that is available as part of the Access 2007 Developer Extensions. It provides a simple way to bundle and deploy Office Access 2007 database applications. The wizard guides you through the steps that are required to bundle stand-alone Access 2007 applications into deployment packages. You can use the Package Solution Wizard to include the Access 2007 Runtime in your packages and to create shortcuts that invoke the appropriate Access file. The output of the Package Solution Wizard is a Windows Installer (.msi) Setup file that guides users through the installation of your Access application.
Additional Reading:
Introducing the Access 2007 Developer Extensions and Runtime
this includes links to download the Developer Extensions and Runtime
Deploying Access 2007 Runtime-Based Solutions
Summary: Find out how to use the Package Solution Wizard to build and distribute solutions that include the Microsoft Office Access 2007 Runtime.
Trusted Locations
If you use a VBA code in your database, it is important to be sure that you add the folders used by your application to the trusted locations list.
See: Trust Center in Access 2007 and 2010
Question: I have installed the Access 2007 Developer Extensions. When I click the Microsoft Office Button, I don't see the new Developer item. Where do I find it?
Answer: You may need to manually enable/re-enable the Developer Extensions in the Acess options.
Steps: Office Button--> Access Options--> Add-ins-->Manage: COM Add-ins--Go...-->Check Microsoft Office Access Developer Extensions COM Add-in-->Ok-->Close Access Options.
Question: How do I add an add-in to a Microsoft Office Access 2007 deployment package created by using the Package Solution Wizard?
Answer:
The Package Solution Wizard makes it easy to create a deployment package that contains your application, the Microsoft Office Access 2007 Runtime, and additional files. However, the Package Solution Wizard does not support deploying additional programs with your application.
See: Adding Programs to Access 2007 Deployment Packages
This article describes how to modify a deployment package that you created by using the Package Solution Wizard to deploy an additional program when the user installs your application. To demonstrate this, you will add the Microsoft Save as PDF or XPS Add-in for 2007 Microsoft Office system programs to an existing deployment package created by using the Package Solution Wizard.
Additional Resources:
What is the Access Runtime Version?
Trust Center in Access 2007 and 2010
Basics for Building Access 2007 Runtime-Based Solutions
How to: Create a Shortcut Menu for a Form, Form Control, or Report