The easiest way that I know, is to place your new version on a shared
network drive and to have your login script copy this version to the local
pc. That way you do not have to copy the front end to each pc yourself and
each user has the new version when they log on to the network.
Another, not so user friendly, way is to send your users an e-mail with a
link to a batch file on a shared network drive. The batch file then performs
the copy.
You may also use Group Policy, but that's a more extensive story than these
simple scripting options.
HTH,
HJ
<fo*******@martecgroup.com> wrote in message
news:11**********************@u72g2000cwu.googlegr oups.com...
I have a database that is being shared on the network. The database it
split up into front end and back end. The back end is residing on the
shared network drive while the front end is on each local pc and just
linked to the back end. All that's contained in the front end are forms
with combo boxes and text boxes that is used for data entry. Is there
a way to code or create a macro to update all the front ends on each
local computer when a new form is added to the front end versus having
to make a copy of it to each pc and overwriting the previous version
that was there. Thanks in advance for any insights and help.