Jim Dettman
jimdettman at earthlink.net
Tue Apr 29 15:25:23 CDT 2003
Drew/Stuart, The only thing I see about Tony's is that it relies on creation date, which might be problem at times. I use a very simple setup: 1. Batch file on the server 2. version table internal to the app. FE checks for the highest version in it's local table vs copy of the FE stored on the server. If the two don't match, I tell the user to update and dump them out. The "update" is a shortcut on their desktop which points to a batch file on the server. The batch file creates directories as needed, copies down files, etc. It's a simple setup and flexible. Jim Dettman President, Online Computer Services of WNY, Inc. (315) 699-3443 jimdettman at earthlink.net -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Dan Waters Sent: Tuesday, April 29, 2003 4:01 PM To: accessd at databaseadvisors.com Subject: RE: [AccessD] Easily copy the latest FE to workstation Another option for this task is a utility written by Tony Toews called Auto FE Updater. It is available at: http://www.granite.ab.ca/access/autofe.htm I set this up in my last company and it worked well! Dan Waters -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Stuart McLachlan Sent: Monday, April 28, 2003 8:15 PM To: accessd at databaseadvisors.com Subject: [AccessD] Easily copy the latest FE to workstation There has been talk about using batch files to update an FE from a server before running it. These all require some degree of customisation, possibly through environment variables, to hard code the location of MS Access and therefore are a PITA to set up on multiple workstations. I decided it was time to build one of my little utilities to simply the process. Now that I've built it, it's available for anyone that wants a copy at http://www.lexacorp.com.pg - click on the Free software button and look for RunLocal under the "Miscellaneous Utilities" It's only a 12KB download RunLocal.Exe: Copies a file to another directory and then opens the file using the default application. Usage: RunLocal PathAndFileName [/A]||[/D RunDirectory] With no switches, the file PathAndFileName will be copied to the default directory - ie the 'Start In' directory specified in a shortcut or the directory from which the batch file or command line is run" With the /A switch the file will be copied to the Application directory - ie the directory where RunLocal.exe is located" With the /D switch the file will be copied to directory RunDirectory, which will be created if necessary Running the program with no parameters displays a simple help screen Example: "RunLocal \\MyServer\SharedDir\MyApp.MDE /D C:\Temp" copies the latest version of MyApp.MDE from the server to C:\Temp andd then opens C:\Temp\MyApp.MDE. It uses ShelllExecute() to find and load the application required so you can use it any registered file type. -- Lexacorp Ltd http://www.lexacorp.com.pg Information Technology Consultancy, Software Development,System Support. _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com