update all front-ends after moving back-end

  • Thread starter Thread starter Christopher Glaeser
  • Start date Start date
C

Christopher Glaeser

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.

Best,
Christopher
 
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.
Click to expand...

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
 
Back
Top