Solved

How do I create an Access 2003 runtime application?

Posted on 2011-09-26
3
149 Views
Last Modified: 2012-05-12
I have a database application created in Access 2003 which I need to distribute to multiple users who do not have Access installed.  From what I can find about this, I need to create a runtime application in order to distribute the software correctly (and legally), however I am struggling to find answers to the following points:

What software do I need in addition to Access 2003 to accomplish this and where can I get this from?
Once acquired, how do I use this software to create the distribution?

Thanks.
0
Comment
Question by:cars1
[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
3 Comments
 
LVL 84

Accepted Solution

by:
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 500 total points
ID: 36598270
First: The Access 2003 Runtime is no longer available except through an MSDN subscription.

However, you can most likely use the Access 2007 or 2010 runtime, which is freely available and easy to distribute. Users can download the correct version of the runtime here:

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

If you decide to go this route, you must thoroughly test your .mde file in that environment. While most times you can easily run a .mde file in the runtime, there are some issues that can arise.

As to deploying, you can use any of the commercial installers, and several of them are free. See here:

http://www.thefreecountry.com/programming/setup.shtml

That's the easy part :)

The hard part is insuring that your application will work on your target machines. Do you have any reference that are NOT the standard, builtin Access references? Open your VBA Editor, click Tools - References, and post back here what you find checked in that listing. If you have any non-standard references, you'll have to insure that you install those on the target machine (if possible).
0
 
LVL 3

Expert Comment

by:John_Arifin
ID: 36598311
You need the Access 2003 Runtime (included in the the Microsoft Office with Access 2003 Packaged). The steps to deploy:
You can refer to http://office.microsoft.com/en-us/access-help/obtain-and-deploy-the-access-2003-runtime-HA001120886.aspx?CTT=1 and its consecutive text in http://msdn.microsoft.com/en-us/library/Aa167800
0
 
LVL 84
ID: 36598410
Note that the only way to legally distribute the Access 2003 runtime is if you own the Microsoft Office Developer product (known as the Access 2003 Developer Extensions). Unfortunately, the only way to get the ADE is through an MSDN subscription. Referring to your link above:

http://office.microsoft.com/en-us/access-help/obtain-and-deploy-the-access-2003-runtime-HA001120886.aspx

Please note this comment from that page:

"Even though the runtime software is included in the Microsoft Office Access 2003 retail product, the right to distribute the runtime is not included. You must purchase the Access 2003 Developer Extensions to obtain a royalty-free license to package and distribute the runtime."

Also, please note I am not implying that you are encouraging anything illegal or unethical, but simply making sure that the author understands the whys-and-wheres of MS licensing (if that is actually possible!).

0

Featured Post

Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

Question has a verified solution.

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

Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
AutoNumbers should increment automatically, without duplicates.  But sometimes something goes wrong, and the next AutoNumber value is a duplicate.  This article shows how to recover from this problem.
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…
This lesson covers basic error handling code in Microsoft Excel using VBA. This is the first lesson in a 3-part series that uses code to loop through an Excel spreadsheet in VBA and then fix errors, taking advantage of error handling code. This l…

739 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