Re: Automatically copy file

  • From: "Deus, Attonbitus" <Thor@xxxxxxxxxxxxxxx>
  • To: "[ISAserver.org Discussion List]" <isalist@xxxxxxxxxxxxx>
  • Date: Thu, 02 May 2002 13:14:40 -0700

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

At 12:16 PM 5/2/2002, you wrote:
>http://www.ISAserver.org
>
>The front-end application build in Access, and everytime I have it update, 
>instead of go to each client computer copy the new updated Access 
>front-end over to the old one. I want it does automatically when user turn 
>on their computer. Basically it s an Access file,  need to copy from 
>server to client, and overwrite the old one.

I know you are not asking for alternatives, but I would suggest the following:

1) Build a version number in the local file- either a local table, or in 
the case of SQL projects, build it as a shared variable value in a module.
2) Have a linked table or SQL table store the "current" software version 
number.
3) On start of application, have it look up the "current" value and compare 
to the stored value.
4) If stored value < lookup value, give dialog box allowing the user to update.
5) If they choose to update, shell to .bat file and quit app.  Bat file 
(after pause confirmation) copies new source to destination.

hth

AD


-----BEGIN PGP SIGNATURE-----
Version: PGP 7.1

iQA/AwUBPNGeMIhsmyD15h5gEQIw1QCfSKEsyZ1ZeDzx0OD3Ci8ZzqDC6WUAn1QS
xMaOwkJSCHlPfJKU0HOqkTA6
=iAbB
-----END PGP SIGNATURE-----



Other related posts: