Solved

How to encrypt a field

Posted on 2009-04-14
2
869 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

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Access vs. Filemaker Pro vs. SQL Server 4 69
default combobox value 12 18
IIF in access query 19 27
Treeview control in 64 bit Office. 2 25
Introduction When developing Access applications, often we need to know whether an object exists.  This article presents a quick and reliable routine to determine if an object exists without that object being opened. If you wanted to inspect/ite…
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…
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…

820 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