Solved

How to encrypt a field

Posted on 2009-04-14
2
866 Views
Last Modified: 2013-11-29
In MS Access 2007, we store user's password in a field of a table. How to encrypt this field so that user can't read the value of the field?

Thanks,

Luchuan
0
Comment
Question by:luchuanc
2 Comments
 
LVL 2

Accepted Solution

by:
dmlyo150 earned 500 total points
ID: 24142754
does the data in the password field actually need to be encrypted or is applying a Mast sufficient?
Open the table in Design view. select the password field and press F6 to access the properties. change the Input Mask to Password.
HTH -davlyo
0
 

Author Comment

by:luchuanc
ID: 24142867
Hi dmlyo150,

The data in the password field actually need to be encrypted.

Thanks a lot for help,

Luchuan
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

When you are entering numbers in a speadsheet, and don't remember what 6×7 is, you just type “=6*7" instead. It works in every cell! This is not so in Access. To enter the elusive 42 in a text box, you have to find a calculator, and then copy the re…
Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…

929 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now