Encripting data fields

[Nuno Guerra]

Hi.
I have an aplication with a User Login Form.
It saves the users passwords in a table field users.
For security reasons i would like that the table field with the password
users could be, in a certain way, encripted.
I know that I can put a format mask so that when I open the table, the
password field has the "*****" instead of the password. But it can be
modified, removed the format mask, and the passwords would be visible.

Is there any solution to encript data fields?
Thanks for any comments.

 

[Jeff Conrad]

Hi Nuno,

You could do something like the following KB articles:

http://support.microsoft.com/?id=209871
http://support.microsoft.com/?id=179371

Looking at the actual data in the tables will reveal a number
that will be pretty much meaningless to anyone that looks
at it.
--
Jeff Conrad
Access Junkie - MVP
http://home.bendbroadband.com/conradsystems/accessjunkie.html
http://www.access.qbuilt.com/html/articles.html

in message:

 

[TC]

If the database has not been secured with Access security, then, what
is to stop someone creating a new database & then linking to the tables
in yours? Then they can view or change the data however they want -
bypassing your login & other forms completely.

TC