I have been puzzled today, and I think I have worked out what is going on.
If you zip a mdb file that uses Access Security, the resulting zip file is no smaller than the original.
Presumably the zip program cannot get in to do what it needs to make any compression.
I initially did this with Windows built in zip capacity, then I downloaded and tried with PeaZip as suggested in a recent Windows 7 thread.
Zipping a Secured database
-
- 3StarLounger
- Posts: 287
- Joined: 09 Mar 2010, 23:16
- Location: Canberra Australia
Zipping a Secured database
Regards
John
John
-
- Administrator
- Posts: 12606
- Joined: 16 Jan 2010, 15:49
- Location: London, Europe
Re: Zipping a Secured database
This is probably because the access security uses some kind of encryption. Encrypted data no longer has the kinds of data patterns that enable it to be compressed.
StuartR
-
- Administrator
- Posts: 78492
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands