Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / General 1 / December 2005

Tip: Looking for answers? Try searching our database.

Automate WinZip self-extract

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Karl - 01 Dec 2005 02:01 GMT
Hi all,

I regularly use FTP to place Self Extracting Zip files on the web for
remote users to update their datafiles. Works very nicely.

I have automated the creation of the initial zip file ( update.zip ),
and can automate the FTP'ing of the SE zip file to the update site.

I have, as yet, been unable to find a way of automating the creation of
a SE zip file from the initial update.zip. I have performed a rather
exhaustive search and have come up with nothing.

Has anyone had experience with this?

Thanks in advance.

Karl
PC Datasheet - 01 Dec 2005 20:29 GMT
Look here:
http://www.access-programmers.co.uk/forums/index.php?

and look in the Code Repository for "Zip Files Within Access"

Signature

                                       PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
                             resource@pcdatasheet.com
                                www.pcdatasheet.com

Over 1000 Access users have come to me for help. My Fees are very
reasonable.

> Hi all,
>
[quoted text clipped - 13 lines]
>
> Karl
PleaseStopAdvertising - 01 Dec 2005 20:41 GMT
> Look here:
> http://www.access-programmers.co.uk/forums/index.php?
>
> and look in the Code Repository for "Zip Files Within Access"

>[garbage snipped]

The CDMA charter prohibits advertising and PC Datasheet is the only
consultant that refuses to adhere to that charter. There are literally
hundreds of competent Access consultants available, that are ethical.  Many
post regularly in this newsgroup, others can easily be located by googling
or visiting the new braintrade.biz or guru.com.

Either Steve's advertising should be stopped or the CDMA charter should be
amended to permit it. Permitting Steve to continue his spamming punishes the
many scrupulous consultants who contribute here but don't advertise.
Karl - 01 Dec 2005 23:10 GMT
Hi Steve,

Thanks for that.

I am unable to find the thread for " Zip Files Within Access " within
the Code Repository.
I can recall following this same link a few weeks ago - I think it was
from a different posting in this group.

Any further ideas?

Karl

> Look here:
> http://www.access-programmers.co.uk/forums/index.php?
[quoted text clipped - 27 lines]
> >
> > Karl
PC Datasheet - 02 Dec 2005 03:41 GMT
See Jim Fortune's response.

The winzip command line package contains full documentation on command line
parameters.

You can use the WinZip command line extensions to zip and  unzip your file.
For example, you can unzip
your file to a known location with wzunzip.exe, do whatever with it , and
then rezip it by shelling to wzzip.exe:

Signature

                                       PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
                             resource@pcdatasheet.com
                                www.pcdatasheet.com

Over 1000 Access users have come to me for help. My fees are very
reasonable.

> Hi Steve,
>
[quoted text clipped - 40 lines]
>> >
>> > Karl
Karl - 02 Dec 2005 04:35 GMT
Hi Steve,

Thanks again.

I feel I have a reasonable handle on the creation of zip files within
an app thanks to the many helpful individuals in this group. The tricky
bit is making that zip file into a self-extracting file from within a
code module.

You see, the remote users simply download the SE file and run it to
update their datafiles. I've tried using plain zip files in the past,
but it exposes the ability for them to change unzip paths etc. which
caused issues.

I'll keep looking, but in the mean time, I'll have another look at the
WinZip site in case I've missed something there.

Karl

> See Jim Fortune's response.
>
[quoted text clipped - 59 lines]
> >> >
> >> > Karl
jimfortune@compumarc.com - 02 Dec 2005 01:39 GMT
> Hi all,
>
[quoted text clipped - 13 lines]
>
> Karl

I bought the full version of WinZip 10.0 for my laptop recently and
noticed a command line support add-on.  The link is:

http://www.winzip.com/prodpagecl.htm

I have not used it.

James A. Fortune
Terry Kreft - 02 Dec 2005 11:50 GMT
Ok is that ironic or what, the idea of WinZip was to get a way from the
command line run PKZip et al and now they bring out command line support for
winzip.

Signature

Terry Kreft

>> Hi all,

<SNIP>
>> Karl
>
[quoted text clipped - 6 lines]
>
> James A. Fortune
jimfortune@compumarc.com - 02 Dec 2005 20:14 GMT
> Ok is that ironic or what, the idea of WinZip was to get a way from the
> command line run PKZip et al and now they bring out command line support for
> winzip.
>
> --
> Terry Kreft

Yeah.  What it really needs is an object model and an automation
interface so that Access can control it.  zlib.dll is good for having
Access compress or uncompress programmatically but I don't think it can
handle creating a self-extracting archive.

James A. Fortune
David W. Fenton - 02 Dec 2005 20:50 GMT
> Ok is that ironic or what, the idea of WinZip was to get a way
> from the command line run PKZip et al and now they bring out
> command line support for winzip.

Hmm. I don't think that was the justification for WinXip. It was to
provide a GUI to something that could be fairly opaque at the
command  line, even for people like me who are no strangers to the
CLI.

I use WinZip for unzipping files because it has an Explorer-like UI,
which is simply easier than doing it from the command line.

Providing a commandline interface just makes WinZip scriptable.

I see no contradiction here at all.

Signature

David W. Fenton                        http://www.bway.net/~dfenton
dfenton at bway dot net                http://www.bway.net/~dfassoc

Terry Kreft - 03 Dec 2005 13:04 GMT
So, in other words, you use Winzip to get away from the command line PKZip.

What contradiction were you referring to (that you say doesn't exist) ?

Signature

Terry Kreft

>> Ok is that ironic or what, the idea of WinZip was to get a way
>> from the command line run PKZip et al and now they bring out
[quoted text clipped - 11 lines]
>
> I see no contradiction here at all.
David W. Fenton - 03 Dec 2005 21:11 GMT
> So, in other words, you use Winzip to get away from the command
> line PKZip.

No, I use it because it's faster and easier, and provides
functionality that is opaque in PKZip. In other words, it's a better
program.

> What contradiction were you referring to (that you say doesn't
> exist) ?

There is no contradiction in WinZip adding a commandline interface.
They are extending a program to make it scriptable.

PKZip was scriptable, but had a UI that few people today can
understand. Adding a commandline interface is not being done to
serve those people. It's being done to serve the people who would
still use PKZip for the scripting.

There is no condtradiction here at all.

Signature

David W. Fenton                        http://www.bway.net/~dfenton
dfenton at bway dot net                http://www.bway.net/~dfassoc

Terry Kreft - 04 Dec 2005 10:06 GMT
So you repeat that you use Winzip to get away from the command line PKZip.

Oh right, only I didn't say it was a contradiction I said it was ironic.

Signature

Terry Kreft

>> So, in other words, you use Winzip to get away from the command
>> line PKZip.
[quoted text clipped - 15 lines]
>
> There is no condtradiction here at all.
PleaseStopAdvertising - 02 Dec 2005 22:25 GMT
> Ok is that ironic or what, the idea of WinZip was to get a way from the
> command line run PKZip et al and now they bring out command line support for
> winzip.

Ironic indeed. Phil Katz (PKzip) owned the market for years, long before
WinZip or even Windows. But they were very slow to put a GUI on it when
people began to become accustomed to Windows. That opened the door for
WinZip.

The WinZip command line tools are not new, however. They have never bundled
them with WinZip but have been available for licensed WinZip users for
years.

The tool that the OP needs has been included with PKzip almost from the
beginning. It's called zip2exe. It runs from the command line and simply
creates a self extracting zip from a zip file.

Note to OP - there are some "freeware" versions of zip2exe floating around.
I'm not certain if they are really freeware or zip2exe PKzip rip-offs.

Randy
Randy Harris - 02 Dec 2005 22:26 GMT
> > Ok is that ironic or what, the idea of WinZip was to get a way from the
> > command line run PKZip et al and now they bring out command line support
[quoted text clipped - 18 lines]
>
> Randy

Oops. I don't seem to know one account from another. Sorry.
Randy Harris
Karl - 07 Dec 2005 06:13 GMT
OK.

I had a thorough look at PKzip and a few others - thanks for the leads.

I ended up purchasing a licence for WinZip Self-Extractor 2.2. The help
file has a rather handy list of command line options to choose from.
Works like a charm.

...........there's a bloke I know in Sydney saying to himself " I told
you so ".

Thanks again

Karl

> > > Ok is that ironic or what, the idea of WinZip was to get a way from the
> > > command line run PKZip et al and now they bring out command line support
[quoted text clipped - 26 lines]
> Oops. I don't seem to know one account from another. Sorry.
> Randy Harris
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.