encrypted password

  • Thread starter Thread starter tracktraining
  • Start date Start date
T

tracktraining

Hi ALL,

I would like to store user passwords into a table. Is there a way for me to
store the passwords in a table where if someone who would opens up the table
(which they should not in the first place), he/she won't be able to
understand/know the password --- encrypted?

Thanks,
Tracktraining
 
In the design of your table, select input mask, and the wizard will give you
a password choice.
Password is stored as asterisks.
Damon
 
No, it is not stored as asterisks. It is stored as whatever the user
entered. The asteriks are only to mask the entery so it can't be seen.

This function will turn it into something unreadable and back again:

Public Function Scramble(ByVal strTxt)
Dim i As Long
For i = 1 To Len(strTxt)
Scramble = Scramble & Chr(Asc(Mid(strTxt, i, 1)) Xor &HE9)
Next i
End Function
 
tracktraining said:
Hi ALL,

I would like to store user passwords into a table. Is there a way for
me to store the passwords in a table where if someone who would opens
up the table (which they should not in the first place), he/she won't
be able to understand/know the password --- encrypted?

Thanks,
Tracktraining
Click to expand...

You can also hide the table.
 
Please advise how the table can be hidden (use VBA to unhide/hide depending
on other functions).
 
Hi Mike,

I will be hiding the tables. But hiding the tables will not fully solve the
problem since anyone with VB/Access knowledge will be able to open it and
view the passwords.

I will try Klatuu's suggestion.

THANKS SO MUCH EVERYONE.
 
True enough but chances are that this would solve more than 90% of your
problems, probably closer to 99%.
Anyone with VBA/Access knowledge will be able to open a form, find the code
for your password and look at it.

If security is that important you need to make sure the weakest link is
taken care of first.
The end user should have no control over picking passwords, they should be
changed on a regular basis, and the person is responsible for their
password. If Fred lets someone else use his password, Fred is still
responsible.
 
after looking at the code again, I see how unscramble works now. that was
just a stupid question on my half.... thanks so much for helping out.

--
Learning


tracktraining said:
Can you also tell me how to unscramble it?
Click to expand...
 
How can a user use code to get at the password if you only use the run-time
version and just use full access for development/design.
 
They can't but then they can't unhide tables or do any of the other
possibilities mentioned.
I've *never* done work for a business when most people didn't know the
password for two or three others and where they used short "easy to
remember" passwords.
 
Back
Top