Solved

How do I create an Access 2003 runtime application?

Posted on 2011-09-26
3
153 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 85

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 85
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

On Demand Webinar: Networking for the Cloud Era

Ready to improve network connectivity? Watch this webinar to learn how SD-WANs and a one-click instant connect tool can boost provisions, deployment, and management of your cloud connection.

Question has a verified solution.

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

Preparing an email is something we should all take special care with – especially when the email is for somebody you may not know very well. The pressures of everyday working life stacked with a hectic office environment can make this a real challen…
In earlier versions of Windows (XP and before), you could drag a database to the taskbar, where it would appear as a taskbar icon to open that database.  This article shows how to recreate this functionality in Windows 7 through 10.
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

691 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