How to Winzip a table?

[thewishla]

Is it possible to automate the process of winzipping a table.

 

[WildHare]

Well, yes, kinda sorta..but remember that you'll have to break the individual table OUT of the database in to a different MDB file - since tables themselves aren't zippable objects. So a quick EXPORT to a named .MDB file should get you the table, and a quick shell call to a batch file that does the zipping should do your trick. I assume winzip has command line options (don't use it myself), or if you are as much of an antique as me, you might even have an old DOS copy of the late and much lamented Phil Katz's PKZIP lying around...

There are two ways to argue with a woman - neither one works.
Another free Access forum:

http://www.forumco.com/jmhare

More Access stuff at

http://www.jmhare.com/wildhare2.htm

 

[IForgot]

You might want to look into the DynaZip library utilities available from Hallogram publishing

http://www.hallogram.com/dynazip/index.html

I have used this with non-Access applications and it did the job well for me. The literature says that it works with a variety of Windows applications so check it out.

Good Luck,
I_Forgot