WinZip and Shell

[Kyle Burns]

I'm working on an Access 97 database project that may not have a network available when it's implemented. To handle updates, I've been looking into replication. What I would like to do is, without user intervention, close and zip the data database and Zip it. I've been trying the posted command line switches for WinZip, but the -a switch doesn't appear to work if an archive doesn't already exist. I don't have enough control over the end environment to install and register any AX controls. Any thoughts?

[Chris Eastwood]

Have you checked out my code at :

http://codeguru.developer.com/vb/articles/1854.shtml ?

it uses the free zip/unzip dll's that are fully compatible with WinZip / PKZip and wraps them up in an ActiveX class module.

Chris Eastwood

CodeGuru - the website for developers
http://codeguru.developer.com/vb