I need to use a reliable compression/decompression function with my Access application. It needs to be able to encrypt, archive and extract to the various folders (all via VBA without users having to go outside of the application).
I started using 7za,exe, which seems to work fine, but it doesn't give me much control if there is a problem. For example, if the users try to archive a ".accdb" file that is open,
So, I thought it might be a good idea to use the 7z.dll or 7-zip.dll files, add a reference in Access and go from there. The problem is that whenever I try to register (via regsvr32) 7z.dll, I get the following:
"The module "7z.dll" failed to load.
"Make sure the binary is stored at the specified path or debug it to check for problems with the binary or dependent .DLL files.
I tried different sources of the 7z files from SourceForge and 7-zip.org
Another site suggested registering "7-zip.dll" instead. This worked fine and allowed me to register it. However, when I went into Access, Tools, References - it wasn't on the list and when I browsed to it and selected the registered file, it said, "Can't add a reference to the specified file".
Anyone have any suggestions (it doesn't have to be 7Z - but it does need to be free to distribute and with the above functionality.