[AccessD] Easily copy the latest FE to workstation

Steve Goodhall sgoodhall at comcast.net
Sun May 4 18:30:31 CDT 2003


I have a set of utilities on my web site that will do this.  It uses custom
properties in the database to control a version number.  Go to
http://www.goodhall.info/STEVE/ and click on the "Useful Software" link.

Regards,

Steve Goodhall


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



More information about the AccessD mailing list