Hello, I’ve looked at various topi

[Gnism]

Hello,
I’ve looked at various topics throughout Tek-Tips and I haven’t come across exactly what I’m looking for. I’d like to be able to press a button that would zip the current database and attach it to an email.

I'm at the point where I can copy my current database and attach it to the email, but it’s the zipping that I can’t figure out. Would I need to use some form of WinZip’s command prompt (how???) or is there code one could use for “WinXP’s compress file” ability if WinZip is not installed?

Gnism.

 

[DerickD]

Hi Gnism,

On winzip.com there is a download for winzip that makes it accessible from command the command line. You could then use these commands via the shell.command function in the code behind the button.

Make some tests with it. I found that I could not zip files that were on network drives, but first had to copy the files locally, then move the zip back to the place in the network from were they from....

Hope this help..!

DerickD

 

[Gnism]

Thanks DerickD, I'll check it out and hopefully get it to do what I need.