is it possible to password protect ms-access 2007 file without encryption

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 encr开发者_运维知识库yption. 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...