AkAlan via AccessMonster.com wrote:
I store my front ends on a web server that all my users have access to and
need to be able to run a script that first checks to see if the front end the
user opens is the most current version. That part I have under control, I
need to be able to run a script that ftp's the latest adp from the web
server to the user desktop if the have an old adp. Right now I have a popup
form that tells the user to update but then they have to go and grab the new
front end manually. Any ideas? Thanks.
The easiest way would probably be to use the VBA shell command in
conjunction with the simple ftp client that comeftp s with Windows
(c:\windows\system32\ftp.exe)
You'll need to set up a script file containing the necessary ftp
commands and provide that as an argument to ftp, e.g.
dim varRtn as variant
varRtn = Shell("ftp -s:filename host")
where filename is your ftp script file and host is the host name or IP
address of the location of your adp updates.
Go to a command prompt in windows and type ftp -? for more information
about the ftp command parameters. Type ftp at the command prompt and
then ? at the ftp> prompt for more information about commands available
for your script.
Depending on your needs you may want to delay the execution of the rest
of your code until your scripted ftp process finishes. If this is the
case you may want to look at the code at
http://www.mvps.org/access/api/api0004.htm.
HTH,
Bruce