Hi,
I have a large 1.3 GB accdb file to which I added security by password protecting it. Accdb file enforces encryption along with password protection so now i am not able to Compress it with winzip.
Is it possible to password protect that file without encryption. Any help is greatly appriciated as both are must for the work i am doing. Thanks, Ashwin
You need to be able to compress it with WinZip? And you want to password-protect but not encrypt? A dirty solution for a dirty problem: you could create a virtual encrypted drive (or similar scheme) that is password protected and put the database file there... When WinZip reads it it'll seem unencrypted, but you need the password to access the file itself.
If the data is actually unencrypted and users have access to it, then any password protection scheme would simply be there as a visual placebo for the ignorant (or an annoyance for the knowing).
The common solution would be not to let users access the file itself, but force them to go through a database server that has authentication...