[AccessD] Using WinZip With Access

Hi Paul,

First of all, you need to get version 9.0 of WinZip.  It is a free upgrade.
There was a security issue with all versions below 9.0.

I have not programmatically done what you are talking about, but I have used
the command line version of WinZip to zip various stuff up.

I use batch files to run them.  Here are two examples:

"C:\Program Files\WinZip\wzzip" -a -spasswordhere psts.zip *.pst

"C:\Program Files\WinZip\wzzip" -a willis.zip willis.pst

The first example shows how to Add all *.PST files to an archive (or create
it new if it does not exist) while password protecting the zip file.
The second example is just adding willis.pst to willis.zip.

If I was you, I would create a batch file with the zip commands and whatever
else you need.  Then I would use the shell command from Access to call the
batch file.  I do not have any examples handy of the shell command, but if
you Google it, I'm sure that you'll find something.

If you have downloaded the command-line version of WinZip, there should be
two files that explain the zip and unzip functions.

Let me know if you have any other questions.

Bobby

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
paul.hartland at fsmail.net
Sent: Tuesday, April 20, 2004 7:48 AM
To: accessd
Subject: [AccessD] Using WinZip With Access


To all,
 
I'm sure one of you out there must have done/attempted this before, I have
an export button on my switchboard which exports two text files (ShiftData
and DowntimeData) using the TransferText method.  I also have a copy of
WinZip 8.0 (or close) installed.
 
What I would like to do is once the text files have been exported I would
like to zip them, has anyone any examples etc that I may look at to achieve
this.  
 
Also would I also need to download the command line interface for WinZip as
well ?
 
Thanks in advance for any help on this.
 
Paul Hartland
Database Designer/Developer.
Join the UK's number one for the internet 
www.freeserve.com/time
-- 
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com