Christopher Glaeser said:
What is the recommended method for updating the links in multiple
front-ends on multiple computers after moving a back-end to a new server?
Access 2003 and Windows XP SP2.
I use a batch file as the target of the users' shortcuts. The batch file
copies the latest FE version from a public folder on the server to the
user's profile. Here's the syntax:
ECHO OFF
DEL "%userprofile%\DbFolder\*.*" /Q
XCOPY "X:\Public\MyGUI.mdb" "%userprofile%\DbFolder" /I
START "MyApp" /MAX "C:\Program Files\Microsoft Office\Office11\MSACCESS.EXE"
"%userprofile%\DbFolder\MyGUI.mdb" /wrkgrp "X:\MyPath\MyWIF.mdw" /user user
This assumes A2003. Leave off the "wrkgrp" switch if you app isn't secured.
HTH - Keith.
www.keithwilby.com