passwords for each employee

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there anyway to set up a password for each employee (not including the
encrypt system)? I have hundreds of employees and a table with a password
for setting up each employee. I want the password that I input in the table
when entering a new employee to prompt when looking up that customer in a
separate record set (enforced referential integrity). So if I click a button
that says "new record" and I select Bob Macro, I want a prompt to ask for his
password or it will cancel. Any help is greatly appreciated. ( I don't care
that the password would show in the background, the information is not that
pertinent)
 
Why are you reinventing the wheel? Set up the built-in user level security
that comes with access. It will let folks enter their userid and password
ONE TIME when they open the application and will apply security and
permissions throughout that session. No need to enter a password everytime
they try to access something secure. Also, you won't have to worry about
them simply ignoring your password routine and opening the table directly.

To do so, you would want to make a backup of your files, read, and reread
the following, and then get started. It is imperative that you follow all
the steps in order to properly secure your database.

Trying to use any homegrown security will almost always result in holes that
you will not see, but your users will manage to find very quickly.

Also be aware that Access (even with user-level security) is not designed to
store highly secure data. There are ways to get around even the ULS when
properly implemented. If you have a highly secure application need, Access
is not the tool for you.


Security FAQ

http://support.microsoft.com/?id=207793



The Security Whitepaper is also worth reading to help you understand.

http://support.microsoft.com/?id=148555



Joan Wild:

www.jmwild.com/AccessSecurity.htm



Lynn Trapp

http://www.ltcomputerdesigns.com/Security.htm
 
You never seem to get it. Every response you give is utterly useless.
Please do not respond to my questions anymore, if you don't have the answer
then simply don't answer.
 
Not sure that I have responded to you before, but if so, and if it was
wrong, then perhaps you need to word your questions better. Since I "never
get it" you must do a very poor job of explaining.

Rest assured, I will no longer respond to your posts.
 
The solution Rick gave was correct and if you had half a brain you'd follow
it. I wouldn't expect much help from anyone with the attitude you exhibit.
 
I think I'm pretty close with this equation, but can't find how to link it to
the password in the table:

Private Sub Command9_Click()

If InputBox("Please Enter a Password") =
"[Employees]![Employee]:[Employees]![Password] " Then
Me!In = Now()
End If

End Sub

"Employees" is the table and "employee"(field) is what I would like the
password(table) to link to, however I have a seperate field on the form
labeled employee and I want it to link to the table when selected. In other
words, I want when "Bob Macro" is selected as an employee for prior to him
clocking in, I want the password linked to his name (enforcing referential
intergrity) connected to the clock-in table to bring up his password. I am
so close, does anyone know the answer? Any HELP is greatly appreciated.
 
You never seem to get it. Every question you ask is utterly stupid. Please
do not ask any more questions. If you don't know the answer, too bad.

--
Paul Overway
Logico Solutions
http://www.logico-solutions.com


[email protected] said:
I think I'm pretty close with this equation, but can't find how to link it
to
the password in the table:

Private Sub Command9_Click()

If InputBox("Please Enter a Password") =
"[Employees]![Employee]:[Employees]![Password] " Then
Me!In = Now()
End If

End Sub

"Employees" is the table and "employee"(field) is what I would like the
password(table) to link to, however I have a seperate field on the form
labeled employee and I want it to link to the table when selected. In
other
words, I want when "Bob Macro" is selected as an employee for prior to him
clocking in, I want the password linked to his name (enforcing referential
intergrity) connected to the clock-in table to bring up his password. I
am
so close, does anyone know the answer? Any HELP is greatly appreciated.

[email protected] said:
Is there anyway to set up a password for each employee (not including the
encrypt system)? I have hundreds of employees and a table with a
password
for setting up each employee. I want the password that I input in the
table
when entering a new employee to prompt when looking up that customer in a
separate record set (enforced referential integrity). So if I click a
button
that says "new record" and I select Bob Macro, I want a prompt to ask for
his
password or it will cancel. Any help is greatly appreciated. ( I don't
care
that the password would show in the background, the information is not
that
pertinent)
Click to expand...
Click to expand...
 
This isn't a child's game, this is responsible professional work. If you
can't answer a question I would appreciate that you wouldn't waste either one
of our time. You have no clue what my database design is entailing and you
only make yourself sound like a fool with a response like "half a brain". If
you don't know then simply don't answer the question.
 
Your response to Rick was anything but professional and VERY childish. If
you're going to ask people for advice, learn some manners.

I DO know the correct answer...and you already were given that answer. I
also know how to do what you want, incorrect as it may be. But I don't
share information with ungrateful morons.
 
I think I'm pretty close with this equation, but can't find how to
link it to the password in the table:

Private Sub Command9_Click()

If InputBox("Please Enter a Password") =
"[Employees]![Employee]:[Employees]![Password] " Then
Me!In = Now()
End If

End Sub

"Employees" is the table and "employee"(field) is what I would like
the password(table) to link to, however I have a seperate field on
the form labeled employee and I want it to link to the table when
selected. In other words, I want when "Bob Macro" is selected as an
employee for prior to him clocking in, I want the password linked to
his name (enforcing referential intergrity) connected to the clock-in
table to bring up his password. I am so close, does anyone know the
answer? Any HELP is greatly appreciated.
Click to expand...

So your designing what appears to be a fairly complex app, you are aware of
the InputBox() function and the Now() function, but are not aware of the
DLookup() function?

Are you also not aware that anyone on your LAN will be able to import or
link to your Employees table from any other Access file and read/edit/delete
any entry they like? You really should re-read Rick's and Paul's earlier
responses. This has big freaking waste of time written all over it.
 
Perhaps my comment was rather harsh and unprofessional, I do apologize for
that and appreciate that you will not be answering my posts.
 
Back
Top