If I build an application (VBA) within an Access database, can I
distribute it to anyone who does not have MS Access? If so, do I need
to distribute supporting files (like the VB runtime module, etc)? Do
I need to set up any configs that they would be mmissing if they do
not have MS Access installed?

- Chris

Both practically and legally you need to have the developer's version
of Access. This provides the tools to create an install of a database
for a machine that does not have Access. The machine gets a "runtime"
version. No modifications can be made to code, forms, etc. with the
runtime. Also, the developers version gives you the license from
Microsoft to distribute the runtime version.

Now for the bad news. The developer's version of Office XP is about
$300 more than the Pro. I believe there is an upgrade available but,
as I recall, it is in the same price range.

In over 10 years of doing Access I have not come accross any
substitute for the runtime.

You might contact someone who has it who could do it for you if you
don't intend to do this on a steady basis.

Good luck

Ira Solomon



On Fri, 01 Oct 2004 23:13:35 GMT, NewToPython <nospam (AT) nospam (DOT) com>
wrote: