Query Password

  • Thread starter Thread starter Sarah
  • Start date Start date
S

Sarah

Hi,
I have one table which has everyone's name, id etc in it,
and one table that has a list of tasks for them to do,
linked by the person's id. Each person can have more than
one task, and each task can be done by more than one
person, so I separated them into two linked tables. Now
I've written queries so that someone can come along and
run one of the queries, which says "enter your name" and
then the person can view all of their tasks. This is an
open terminal (no-on can log in etc) So in order to stop
them from typing in other people's names and viewing their
tasks I have added another field into the the personnel id
table called Password. If you open the table, there's a
list of everyone plus their password which is shown as *'s
so that they can't be read. (Using the Input Mask =
password setting).
The query then says "Enter Name" [OK] "Enter Password"
[OK] and so the records are filtered by the matching name
and password.
Still With Me ??!!
The problem is that when the window appears that
says "Enter Password", the password appears as text in
that box. There isn't much point in having a secret
password that anyone passing by can see, so is there some
way of changing *this* input mask so that the password
entered into the query box is seen as *'s??
Please Help!
 
Not with a parameter query. Instead, build a small form with one textbox and
a button. Set the Inputmask of the textbox to Password, then open your Task
form (or run your query, with an appropriate Where clause) from the OnClick
event of the button.

Of course, there's likely nothing to stop people from opening the table
directly and viewing all the passwords, tasks, etc etc, unless you've
properly implemented Access security.
 
Back
Top