Compact/Zip/Self Extracting/Posting to FTP

  • Thread starter Thread starter Dorian C. Chalom
  • Start date Start date
D

Dorian C. Chalom

I am looking to automate as much of this as possible

Compact the Database
Zip the Database
Create a Self Extracting
and post the self extracting file to an FTP.

I know this cannot all be done in Access but It is an Access DB we are
working with.

Thank you.
 
Dorian C. Chalom said:
Compact the Database
Click to expand...

See the DBEngine.CompactDatabase method in VBA help for more details.
Zip the Database
Click to expand...

I've had lots of success using the open source Infozip DLLs.

Compression DLLs, OCXs, etc
http://www.granite.ab.ca/access/compression.htm

Not sure about the rest.

Tony
--
Tony Toews, Microsoft Access MVP
Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
For a free, convenient utility to keep your users FEs and other files
updated see http://www.autofeupdater.com/
Granite Fleet Manager http://www.granitefleet.com/
 
I prefer the Infozip DLLs as well, but in the od chance that you aren't
allowed to put them on your machine, here's something that uses the zip
functionality built into Windows XP and later:

http://www.naterice.com/blog/template_permalink.asp?id=64
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

Disclaimer: Any code or opinions are offered here as is. Some of that
code has been well tested for number of years. Some of it is untested
"aircode" typed directly into the post. Some may be code from other
authors. Some of the products recommended have been purchased and
used by the author. Others have been furnished by their manufacturers.
Still others have not been personally tested, but have been
recommended by others whom this author respects.

You can thank the FTC of the USA for making this disclaimer necessary.
 
Arvin Meyer said:
I prefer the Infozip DLLs as well, but in the od chance that you aren't
allowed to put them on your machine, here's something that uses the zip
functionality built into Windows XP and later:

http://www.naterice.com/blog/template_permalink.asp?id=64
Click to expand...

Very interesting but ....

"This script is provided under the Creative Commons license located at
http://creativecommons.org/licenses/by-nc/2.5/ . It may not be used or
commercial purposes with out the expressed written consent of
NateRice.com/"

For a relatively short VBScript function?!?!?!

Tony

--
Tony Toews, Microsoft Access MVP
Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
For a free, convenient utility to keep your users FEs and other files
updated see http://www.autofeupdater.com/
Granite Fleet Manager http://www.granitefleet.com/
 
Tony Toews said:
Very interesting but ....

"This script is provided under the Creative Commons license located at
http://creativecommons.org/licenses/by-nc/2.5/ . It may not be used or
commercial purposes with out the expressed written consent of
NateRice.com/"

For a relatively short VBScript function?!?!?!
Click to expand...

Now this is amusing. I just got an email from someone using an Swiss
email address calling me an "*sswhole" in reply to my posting.

Dunno what I did. Oh well.

Tony
--
Tony Toews, Microsoft Access MVP
Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
For a free, convenient utility to keep your users FEs and other files
updated see http://www.autofeupdater.com/
Granite Fleet Manager http://www.granitefleet.com/
 
Tony Toews said:
Now this is amusing. I just got an email from someone using an Swiss
email address calling me an "*sswhole" in reply to my posting.

Dunno what I did. Oh well.
Click to expand...

Sorry to hear that. We don't get too much of that kind of abuse here. It
takes all kinds I guess.
 
Back
Top