Chris Sergent said:
Hi,
I work for the state of Illinois and we would like to
distribute runtime MS Access databases. Some staff believe
this makes other versions corrupt upon install.
You have to remember that installing the runtime is still much the same as
installing ms-access on those machines.
I would
like to locate documentation as to refute this claim.
The question you are actually asking is:
Do problems exist when you install another version of ms-access on a
existing pc? The answer is most certainly yes. The fact of the matter,
installing the runtime is really the same as installing ms-access. (there is
only few things removed...but for all intensive purposes...you ARE
INSTALLING ms-access).
So, we don't need some supporting document. Armed with the knowledge that
the runtime is really the same as installing ms-access, then we ONLY have to
ask is there a problem when you install more then one version of ms-access
on a pc? The answer is yes!
That install can be up to 150 megs in size, and adds in the neighbourhood of
1000+ entries in the registry. It is a very large install, and one that is
normally part of office.
Of course, when you use the runtime, then you also have to provide the menu
bars and user interface. (on the other hand..any good developer thinking of
distributing their software no doubt hid the ms-access interface a LONG LONG
time ago...else one could not possibly be thinking of distributing some
software...right?). And, I sure you always distribute a split database (and,
of course always a mde..right?). I am just saying that if you have not had a
good amount of developer time hiding the access interface, and doing the
basic stuff like providing code to "re-link" your split database..then you
are much like a first year med student wanting to do brain surgery. You are
not ready for that step yet!
Assuming that you have all the above done (and a lot more), then if you are
planning to distribute your application to a lot of machines I would
consider purchasing a good installer AND ALSO purchases some scripts from
www.sagekey.com. Purchasing the scripts from sagekey will turn out to be a
bargain in terms of reduced support costs.
sagekye can also supply scripts for the MSI (Microsoft installer),so you can
save the cost of having to purchase a installer..and only need the scripts.
(windows 2000, and later usually has the MSI). If you need to install on
early versions of windows (win98)..then I would purchase a commercial
installer and then purchase the scripts for that installer from sagekey.
You can see the list of problems the above fixes.
http://www.sagekey.com/products/acc2000/msi.asp
Here is a great article and some reading
http://www.sagekey.com/whats/article.asp