update database on 15 PCs from Server master copy

J

Jim GUN

I have a Database on a server and copies on 15 PC. When I update the master
copy on the server I have to go to each Pc and copy it. Is there a way that
I can automatically program the coping automatically?
 
A

Arvin Meyer [MVP]

If you have multiple databases and want to get just one at a time, you can
use a utility such as Starter:

http://www.datastrat.com/Download/Starter.zip

or autofeupdater from Tony Toews.

If your system administrator allows it, a simple batch file using the XCopy
command is all you need to copy the file over. The users simply need to use
the utility or batch file to start their databases.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
T

Tony Toews

Jim GUN said:
I have a Database on a server and copies on 15 PC. When I update the master
copy on the server I have to go to each Pc and copy it. Is there a way that
I can automatically program the coping automatically?
Click to expand...

I specifically created the Auto FE Updater utility so that I could
make changes to the FE MDE as often as I wanted and be quite confident
that the next time someone went to run the app that it would pull in
the latest version. For more info on the errors or the Auto FE
Updater utility see the free Auto FE Updater utility at
http://www.granite.ab.ca/access/autofe.htm at my website to keep the
FE on each PC up to date.

In a Terminal Server or Citrix environment the Auto FE Updater now
supports creating a directory named after the user on a server. Given
a choice put the FE on the Citrix server to reduce network traffic and
to avoid having to load objects over the network which can be somewhat
sluggish.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
 
Top