update all front-ends after moving back-end

  • Thread starter Christopher Glaeser
  • 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
 
K

Keith Wilby

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Multiple front-ends to single back-end 6
Front End and Back End 2
Single Front End with split back ends 3
User level security re: front-end and back-end 1
Where Should The Front End Live? 12
Update back-end tables, fields, relationships etc... 6
delete all links in front-end 4
repost - two front-end users were able to update same record 10

Top