Improve company productivity with a Business Account.Sign Up

x
?
Solved

Making a Access 2007 and Access 2010 Runtime

Posted on 2011-09-08
2
Medium Priority
?
334 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
2 Comments
 
LVL 86

Accepted Solution

by:
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 150 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

Improve Your Query Performance Tuning

In this FREE six-day email course, you'll learn from Janis Griffin, Database Performance Evangelist. She'll teach 12 steps that you can use to optimize your queries as much as possible and see measurable results in your work. Get started today!

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.

Join & Write a Comment

Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…
Are you working to mount the dismounted Exchange 2013 database? Then the best course of action is to analyze the causes of Database issue, their probable solutions and decide for the appropriate course of action.
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…

608 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