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

x
?
Solved

Making a Access 2007 and Access 2010 Runtime

Posted on 2011-09-08
2
Medium Priority
?
329 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 85

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

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

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

We live in a world of interfaces like the one in the title picture. VBA also allows to use interfaces which offers a lot of possibilities. This article describes how to use interfaces in VBA and how to work around their bugs.
MSSQL DB-maintenance also needs implementation of multiple activities. However, unprecedented errors can hamper the database management. In that case, deploying Stellar SQL Database Toolkit ensures fast and accurate database and backup repair as wel…
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you! In this Micro Tutorial, you'll learn yo…
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …

872 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