unzip

Does any one know how I can unzip files in VBA on Access 97?

Bits of code would help (in VB or VBA).

Thanks

use the SHELL function against PKZIP.exe!

Do you know what PKZIP.EXE is? It is almost equivalent to WinZip. It is the DOS version of zip.

If you don't have it, go to the internet and do a search on PKZIP.

Thanks for the suggestion, but I can't get it to work.
Are ther any options to be set??
Is there a problem with very large files or unknown file types??

I sent you an OCX control that should help.

hi.... nevyn.....

I got u the best solution i found ever..it is VB code uses Unzip.dll, and ZIp.dll.... u can have all the controls over everything u wants to do with zip files...and it includes documentation for use it.... Great!!!!! ....

All the best...

Thanks, I will try your solutions and let you know