Solved

Making a Access 2007 and Access 2010 Runtime

Posted on 2011-09-08
2
319 Views
Last Modified: 2013-11-05
I am trying to make a runtime version of my application created in Access 2007 but running under Office Prof 2010. How do I do it? Is it via the Package Solution route? I have read many articles about this but I am still very confused. I also have an application created in Access 2010 - is the procedure to create a runtime for it the same as for above?
Many thanks
0
Comment
Question by:kotzejd
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 84

Accepted Solution

by:
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 50 total points
ID: 36501646
To make a Runtime version of your application, you simply save the file with the .accdr extension. You would then deploy that file to your end users. Alternatively, you can use the Package Wizard to bulid an installation file, which can include the Access Runtime, but that's not required, and many find it to be more trouble than it's worth.

If you don't use the Package Wizard, then if your end users do NOT have the full version of Access on their machine they will need to download and install the Access Runtime, which is free and available here:

http://www.microsoft.com/download/en/details.aspx?id=10910

Once they install that file, they'll be able to use your application in the runtime mode. If they do have the full version of Access, then you don't need to deploy the runtime - just deploy your database with the .accdr extension, and the database will run.

Note, however, that you should thoroughly test your app in the runtime mode before you deploy it. There are quite a few differences between a Runtime database and a "normal" database:

http://msdn.microsoft.com/en-us/library/bb501030%28v=office.12%29.aspx
http://office.microsoft.com/en-us/access-help/deploy-an-access-2007-application-HA010218864.aspx

Also note that if your end users have the full version of Access, then they can simply switch back to the .accdb extension and have full rights to modify your database. In most cases, you're far better off deploying your file in the .accde format, which compiles the database and removes the ability for end users to modify Forms, Report and Code (macros or modules).
0
 

Author Closing Comment

by:kotzejd
ID: 36591416
I had some additional problems but decided to put on hold
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s ManageEngine webinar, where attendees received a comprehensive look at the ma…
A Stored Procedure in Microsoft SQL Server is a powerful feature that it can be used to execute the Data Manipulation Language (DML) or Data Definition Language (DDL). Depending on business requirements, a single Stored Procedure can return differe…
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…

734 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question