[AccessD] Easily copy the latest FE to workstation

Dan Waters dwaters at usinternet.com
Tue Apr 29 15:00:39 CDT 2003


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




More information about the AccessD mailing list