Need help with macro to compress and send to ftp

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a large Access DB. I want to create a macro to create a compressed
file of the DB (I would ordinarily right click in Explorer: Send to
Compressed (zipped) Folder) and then send the compressed folder to an FTP
site (with password protection). Is there a way to do it inside Access when
the DB is open?
 
Brossyg said:
I have a large Access DB. I want to create a macro to create a compressed
file of the DB (I would ordinarily right click in Explorer: Send to
Compressed (zipped) Folder) and then send the compressed folder to an FTP
site (with password protection). Is there a way to do it inside Access
when
the DB is open?
Click to expand...

I'm not sure about compressing the file into a zipped directory (this could
certainly present a challenge if you are running the code from the database
you want to compress), but I'm sure it can be done.

The following two links show two different methods for FTP in VBA. I have
used the first one with no problems at all:

http://www.mvps.org/access/modules/mdl0015.htm
http://www.mvps.org/access/modules/mdl0037.htm

Ed Metcalfe.
 
OK. I do have an existing script (.txt) that I use to upload another file I
upload/download from my site frequently. It is executed by simply clicking
on a one-line .bat file. Inside the .bat file, the command is:

ftp -s:myfileupload.txt

How would I execute this command from a button control in Acess?
 
Back
Top