?
Solved

How do I create an Access 2003 runtime application?

Posted on 2011-09-26
3
Medium Priority
?
159 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 2000 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

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

Question has a verified solution.

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

It’s the first day of March, the weather is starting to warm up and the excitement of the upcoming St. Patrick’s Day holiday can be felt throughout the world.
Microsoft Access is a place to store data within tables and represent this stored data using multiple database objects such as in form of macros, forms, reports, etc. After a MS Access database is created there is need to improve the performance and…
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
Suggested Courses
Course of the Month10 days, 6 hours left to enroll

762 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