Compact/Zip/Self Extracting/Posting to FTP
in [General]
|
From: Dorian C. Chalom on 1 Dec 2009 15:11 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.
From: Tony Toews [MVP] on 1 Dec 2009 15:42 "Dorian C. Chalom" <DChalom(a)Comcast.net> wrote: >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/
From: Arvin Meyer [MVP] on 2 Dec 2009 12:46 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]" <ttoews(a)telusplanet.net> wrote in message news:uqvah59m4gfin5uhv97t17kcgrnrmgkr43(a)4ax.com... > "Dorian C. Chalom" <DChalom(a)Comcast.net> wrote: > >>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/
From: Tony Toews [MVP] on 2 Dec 2009 18:38 "Arvin Meyer [MVP]" <arvinm(a)mvps.invalid> wrote: >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/
From: Tony Toews [MVP] on 3 Dec 2009 01:59
"Tony Toews [MVP]" <ttoews(a)telusplanet.net> wrote: >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/ |