• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 178
  • Last Modified:

How do I create an Access 2003 runtime application?

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
cars1
Asked:
cars1
  • 2
1 Solution
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
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
 
John_ArifinCommented:
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
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
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

Vote for the Most Valuable Expert

It’s time to recognize experts that go above and beyond with helpful solutions and engagement on site. Choose from the top experts in the Hall of Fame or on the right rail of your favorite topic page. Look for the blue “Nominate” button on their profile to vote.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now