Solved

How do I create an Access 2003 runtime application?

Posted on 2011-09-26
3
141 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
  • 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

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

708 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

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now