oGSV Ethics Gradient (Doug Wilson)
Quote:
>I want to encrypt fileds in an access table then encrypt the database or
>put some type of security on it so that other access users can not see the
>specific data. Is there a way to do encryption with access on field by
>field basis?
>I am using access 97 or can use access 95.
Someone please correct me if I'm wrong, but as far as I've been able
to determine you can implement security (who can read or make changes
to data and/or data structure) on database objects like tables and
queries but not on individual fields.
Suggestion: You could lock everyone out of the tables (no read access)
and only allow data to be read through queries which do not retrieve
the fields you wish to restrict.
"Since our problems have been our own creation
They also can be overcome."
-- George Harrison (Cloud Nine)
* - * - * - * - * - * - * - * - * - * - * - * - * - * - * - * - *
If you are a human who wants to reply via email,
please remove the word "SPAMBLOCK" from my email address.
* - * - * - * - * - * - * - * - * - * - * - * - * - * - * - * - *
ACCESS SECURITY