Compact/Zip/Self Extracting/Posting to FTP

[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.

 

[Tony Toews [MVP]]

Compact the Database

See the DBEngine.CompactDatabase method in VBA help for more details.

Zip the Database

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/

 

[Arvin Meyer [MVP]]

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.

 

[Tony Toews [MVP]]

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

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 [MVP]]

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?!?!?!

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/

 

[Arvin Meyer [MVP]]

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.

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

 

[JP]

See http://www.rondebruin.nl/tips.htm for a "guilt free" version of
the code on that page.

 

[Tony Toews [MVP]]

See http://www.rondebruin.nl/tips.htm for a "guilt free" version of
the code on that page.

Hehehehe. Thanks.

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/