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.
Who is Participating?
Scott McDaniel (Microsoft Access MVP - EE MVE )Connect With a Mentor Infotrakker SoftwareCommented:
This might help you understand the differences beteen the two environments:
Leigh PurvisConnect With a Mentor Database 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.
jegajothyretiredAuthor Commented:
In response to LPurvis, how do  create a runtime version of a db that I already have.  What are the steps. thank u
Cloud Class® Course: Amazon Web Services - Basic

Are you thinking about creating an Amazon Web Services account for your business? Not sure where to start? In this course you’ll get an overview of the history of AWS and take a tour of their user interface.

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.)

jegajothyretiredAuthor 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 PurvisConnect With a Mentor Database 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)?
JVWCConnect With a Mentor Commented:
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).
jegajothyretiredAuthor Commented:
LSM's link to the article provides a very good to the problem. thank u.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.