Need Help With Password Protect Form instructions on Microsoft Sup

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

Guest

I have followed the Microsoft support instructions to password protect a form
but does anyone know how I change their password from "PASSWORD" to something
else?

Im probably being really thick but Im new to this and couldnt figure it out...

Ta :)
 
Here are some instructions I have posted in the past Julia:
What the module code does is take a text string you provide and makes
a number out of it through the code.

What you need to do is open the Immediate Window (CTRL + G)
and then type right into the window something like this:

?KeyCode("julia")

(put whatever password you want in between the quotes)

....after you hit enter on the keyboard you will see a number displayed
and it could be negative. *That* number is what goes into the table.
So if someone was to look at the "password" in the table all they would
see is a number. If they tried to use that number to open the form it
would not work. It is certainly not hacker proof, but it can really keep
out the Access newbies.
--
Jeff Conrad
Access Junkie - MVP
http://home.bendbroadband.com/conradsystems/accessjunkie.html
http://www.access.qbuilt.com/html/articles.html

in message:
 
Thanks so much Jeff!!!!

Jeff Conrad said:
Here are some instructions I have posted in the past Julia:

What the module code does is take a text string you provide and makes
a number out of it through the code.

What you need to do is open the Immediate Window (CTRL + G)
and then type right into the window something like this:

?KeyCode("julia")

(put whatever password you want in between the quotes)

....after you hit enter on the keyboard you will see a number displayed
and it could be negative. *That* number is what goes into the table.
So if someone was to look at the "password" in the table all they would
see is a number. If they tried to use that number to open the form it
would not work. It is certainly not hacker proof, but it can really keep
out the Access newbies.

--
Jeff Conrad
Access Junkie - MVP
http://home.bendbroadband.com/conradsystems/accessjunkie.html
http://www.access.qbuilt.com/html/articles.html

in message:
Click to expand...
 
Back
Top