Zipping Files in Code

[PSUIVERSON]

I have a program that outputs specific queries from my tables into data files on our network. I have no problem with the VBA to output these files as .txt or .prn files. However, I need to be able to Zip these files once I am finished outputting them to the specific directories etc.

Anyone know of the VBA to Zip files from an ACCESS module?

Thanks

 

[KenReay]

Hi

there may be a neater way, but my first thought would be to write atext file as a batch file (.bat) containing the commands to run zip, and zip the relevant file(s), you can easily do this from code, then shell and execute the batch file Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[RobCPA]

Take a look at thread705-426953

 

[PSUIVERSON]

Thanks ROB. I'll give that a shot and let you know how I make out...Appreciate it...

 

[Rick39]

I backup multiple db's daily with this:

thread705-474948

 

[PSUIVERSON]

That's awesome as well...I'll let you guys know how I make out. Appreciate the generous help...