[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 398
  • Last Modified:

Access 2007 runtime

My OS is windows 7 and I have Office 2007 and Access 2007.  I have just downloaded the Access 2007 runtime app from Microsoft.
I am trying to create a small db with my usernames and passwords that I could carry with my laptop without having to have a license version of either Office or Access 2007.  
I have already created a small db in Access 2007, now how do I make it as a runtime version.
Thank u.
4 Solutions
Leigh PurvisDatabase DeveloperCommented:
You'd literally only need to install the runtime package on your laptop - then launch the application as normal (either from an Explorer window or a shortcut).
The runtime alone won't give you default Ribbon commands or the ability to open the application from its UI.

However if the laptop is the same machine you're describing with Office (and Access) installed on it then the Runtime isn't required at all.

You could pack this up as part of an install package - but you don't need to.  Once the runtime is installed on the laptop, then it's capable of running your Access applications.
jegajothyAuthor Commented:
In response to LPurvis, how do  create a runtime version of a db that I already have.  What are the steps. thank u
Leigh PurvisDatabase DeveloperCommented:
There's no such beast as a "runtime verison of a db".
It's simply your existing application, executing in a runtime installation of Access.
It's that simple.
If you want to create an MDE/ACCDE then that's different.  And isn't at all required for your application to run on a PC which only has the runtime version of Access installed.

All you need to be prepared for is that there is no Database Window/Navigation Pain and so you have to give your application the means to navigate around it without the list of database objects from which to select.
(But that's a given in any application worth releasing.  If this is for your own personal use then you might not have gone to such lengths as yet.)

Fill in the form and get your FREE NFR key NOW!

Veeam is happy to provide a FREE NFR server license to certified engineers, trainers, and bloggers.  It allows for the non‑production use of Veeam Agent for Microsoft Windows. This license is valid for five workstations and two servers.

jegajothyAuthor Commented:
In response to Purvis, do u have a sample small db of a runtime version, so that I an see how it looks like. thank u
Leigh PurvisDatabase DeveloperCommented:
Well... no - I don't.  Because there is no such thing.  That's what I'm saying.
The runtime is a version of Access which supports running applications but not developing them.
(The clue is in the name.)
All it does is run applications.  The exact same applications you can run under the full retail Access install.
It's just without the menubars etc that you normally have available.

Does your application have a Switchboard form (or a self-made Main Menu type alternative)?
You can emulate the runtime on your full version by starting the DB from command line or a shortcut on your desktop, using the /runtime switch.
This would show you what it will be like on your laptop.

This article describes how to use switches.

Leigh PurvisDatabase DeveloperCommented:
Or, since you're using Access 2007, by temporarily renaming the application file with an ACCDR extension (instead of ACCDB or MDB).
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
This might help you understand the differences beteen the two environments:

jegajothyAuthor Commented:
LSM's link to the article provides a very good to the problem. thank u.

Featured Post


Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now