Hello Everyone,
My question is quite simple. I have frontend databases in 8 locations in a
network. Do I have to go to each computer and update each one when I make
changes to the forms?
Thanks,
JM
Michel Walsh - 26 Feb 2007 20:54 GMT
Yes, and no. Each computer has to be updated, but you don't necessary have
to move to each station. There are some 'tools' out there that allow you to
do it almost automatically, as example, check the Front End Updater at
http://www.granite.ab.ca/accsmstr.htm (It assumes that the database is
split into a back end, the data, and the front end, the presentation).
Hoping it may help,
Vanderghast, Access MVP
> Hello Everyone,
> My question is quite simple. I have frontend databases in 8 locations in a
[quoted text clipped - 3 lines]
> Thanks,
> JM
kingston - 26 Feb 2007 21:08 GMT
Yes, unless you have a different delivery mechanism (other than yourself).
You can set up a "download" or "updates" folder on the network that people
can access. Then they can replace the front-end file themselves. Or you can
e-mail them the updates if your mail server allows it. You can also write a
routine into the front-end that checks for updates and replaces objects (e.g.
forms) when the user first opens the file. There are probably a lot of other
ways to do this; HTH
>Hello Everyone,
>My question is quite simple. I have frontend databases in 8 locations in a
[quoted text clipped - 3 lines]
>Thanks,
>JM
Albert D. Kallal - 26 Feb 2007 21:53 GMT
> Hello Everyone,
> My question is quite simple. I have frontend databases in 8 locations in a
> network. Do I have to go to each computer and update each one when I make
> changes to the forms?
If you need to update your word program to the next version, you have to go
to each machine and update it. The same goes for most software, and that
includes the software your team of developers and analysts is making. You
are deploying software to those machines, and like all other software, you
need to either go to each machine, or your software can provide some type of
automated update system.

Signature
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
pleaseNOOSpamKallal@msn.com