Standalone database app

  • Thread starter Thread starter Cnews-ms
  • Start date Start date
C

Cnews-ms

I want to know if I can distribute my access database and app to internal
clients if I buy the office develeopment kit. They dont have a demo so I
dont want to take the plunge until I know it will work.

regards

cr

--
http://QLiner.com



Where does the family start? It starts with a young man falling in love with
a girl - no superior alternative has yet been found. - Sir Winston Leonard
Spencer Churchill
 
Cnews-ms said:
I want to know if I can distribute my access database and app to internal
clients if I buy the office develeopment kit. They dont have a demo so I
dont want to take the plunge until I know it will work.

The Office Developer's Version is at its best when you are distributing to
"known" users meaning that you have some control (or at least knowledge) of
the hardware/software on their systems and where NO version of Access is
already installed.

If you need to distribute to users who are a mixed bag where some have
Access, some don't, and those that do have various versions then things can
get nasty. Most of the problems involve the installed version of Access
and your Runtime installation stepping on each other toes (so to speak)
regarding file associations and registry settings.

In many companies there are people who have Access installed by virtue of
having the Office Pro Suite who have never even opened Access. It is
simply "there". You would likely not have too many problems with these
types. Users who need to use your app along with retail Access for their
own purposes are where the snags are most common. Even if it's the same
version of Access there can be problems although that is less likely than
if the versions are different.

You can augment the Developer's distribution with scripts from Sagekey
together with using a product like Wise or InstallAnywhere for the
installation and greatly reduce these problems, but you're talking about a
bit more cash layout to go that route. Many developers just create a
multi-purpose install program where they only install the Runtime on PCs
where Access is not present and on PCs where it is installed just provide
an application file of the proper version. Most serious developers have
multiple versions of Access for this reason.
 
Just to add to Rick's remarks, which do well pointing out some of the issues
with Office Developer.

If all of your clients have Microsoft Access and all have the same version,
you may not even need Office Developer....just distribute your MDB. I use
an inexpensive/freeware installer called Installer2Go (www.dev4pc.com) with
some custom VB scripts I wrote. I distribute multiple versions (97, 2000,
2002)...and only install the runtime if Access is not found on target PC.
The Package and Deployment Wizard (PDW) that is provided with Office
Developer is woefully inadequate, i.e., does not create proper shortcuts,
allows multiple installs of the same package, does not install registry
keys, etc. etc. While some of these issues can be addressed using work
arounds, the best solution is not to use PDW at all.

FWIW, the 2003 version (now called ADE) is an improvement, but Microsoft has
still not addressed the issues concerning their run-time installer, so, if
the target PC has Access, you'll make a mess of your client's PC.
 
Back
Top