Haslett, Andrew
andrew.haslett at ilc.gov.au
Mon May 5 01:58:25 CDT 2003
We just use this simple batch script: *********************************************** *@echo off *if not exist "c:\Documents and Settings\All Users\Data\MyDB_V1.mde" goto getdb: goto startdb :getdb *md "c:\Documents and Settings\All Users\Data" >nul *del "c:\Documents and Settings\All Users\Data\MyDB_V*.mde" >nul *copy l:\master\MyDB_V1.mde "c:\Documents and Settings\All Users\Data" >nul *:startdb *"c:\program files\microsoft office\office\msaccess.exe" "c:\Documents and Settings\All Users\Data\MyDB_V1.mde" ********************************************** The database in this example is called MYDB_V1.mde. When I create a new version, following conventions, it will be called v1.1 or v2 etc, so we simply change the name in the script. The shortcut on all users desktops points to this shortcut. HTH, Andrew -----Original Message----- From: Steve Goodhall [mailto:sgoodhall at comcast.net] Sent: Monday, 5 May 2003 9:01 AM To: accessd at databaseadvisors.com Subject: RE: [AccessD] Easily copy the latest FE to workstation 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 _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com IMPORTANT - PLEASE READ ******************** This email and any files transmitted with it are confidential and may contain information protected by law from disclosure. If you have received this message in error, please notify the sender immediately and delete this email from your system. No warranty is given that this email or files, if attached to this email, are free from computer viruses or other defects. They are provided on the basis the user assumes all responsibility for loss, damage or consequence resulting directly or indirectly from their use, whether caused by the negligence of the sender or not.