Password Protected form

  • Thread starter Thread starter LT Larry via AccessMonster.com
  • Start date Start date
L

LT Larry via AccessMonster.com

Afternoon All
I have a secured data base with users defined yada yada. I found the need
to password protect an individual form. I followed the instructions under
article 209871 " ACC2000: ". Everthing works so far. My question is where
is the actual password stored and how do I change it. Is it in the string
line of the Module or the table. I originally thought it was in the table
but the number I entered in the table does not work. The only PW that works
is (PASSWORD) as outlined in the article. Secondly (I am still trying to
figure this one out)" To determine what the corresponding KeyCode is for a
particular string, type the following in the Immediate window and then
press ENTER: ?KeyCode ("TestString")I was completely locked on until I ran
into this sentence.
Any Help is appreciated

Thanks for taking the time to help
 
If you have user-level security in place, why are you adding a form
password? Just don't let he unauthorized people get to that form. Adding a
form password kind of defeats the whole purpose of setting up user-levle
security and allowing your users to enter one userid and password when they
first open the file and then be able to get to what they need without
annoying pop-up password prompts.
 
"LT Larry wrote in message:
Afternoon All
I have a secured data base with users defined yada yada. I found the need
to password protect an individual form. I followed the instructions under
article 209871 " ACC2000: ". Everything works so far. My question is where
is the actual password stored and how do I change it. Is it in the string
line of the Module or the table. I originally thought it was in the table
but the number I entered in the table does not work. The only PW that works
is (PASSWORD) as outlined in the article. Secondly (I am still trying to
figure this one out)" To determine what the corresponding KeyCode is for a
particular string, type the following in the Immediate window and then
press ENTER: ?KeyCode ("TestString")I was completely locked on until I ran
into this sentence.
Any Help is appreciated
Click to expand...

Most peculiar.

I have experience with User Level Security, as well as that particular KB article
and I must ask, if you have already set up ULS *properly* why do you feel
the need to use the KB article code to secure this one form?

The KB article code is really intended for databases that have not been secured
with a workgroup file and ULS. Since you have already set up ULS, simply
deny the appropriate Groups the ability to open the form. Access will take
care of the rest. You're making a lot of extra work for yourself here.

Just to be clear, are you using ULS or is your security *system* something
you made?
 
I set ULS, but ran into a problem with read only users. I have a particular
form that creates (Lets say)Identification cards that carry a digital
signature and dont want read only users to acess and print from that form
but I dont want to restricted acess to all forms. When setting up ULS I
noticed you could restrict access to forms or queries but not an individual
form (Maybe I missed something?). That is why I created a seperate password
login for the form. I am making since???? If there is an easier way I am
all for it.

Thanks again
Larry
 
User level security allows you to specify what type of access each user or
group has to each individual object in the database.

For example:
John can look open and modify the design of FormX
Sue can open FormX but not modify the design
Bill can't open or modify FormX (no access to it)
 
in message:
I set ULS, but ran into a problem with read only users. I have a particular
form that creates (Lets say)Identification cards that carry a digital
signature and don't want read only users to access and print from that form
but I dont want to restricted access to all forms. When setting up ULS I
noticed you could restrict access to forms or queries but not an individual
form (Maybe I missed something?). That is why I created a separate password
login for the form. I am making since???? If there is an easier way I am
all for it.
Click to expand...

Yes, there is a much easier way.

Again, I am assuming you have already set ULS properly and created custom
groups for your users and put them in whatever groups they need to be in.
Might be wise to create a backup of your database before going any further
as well. If you have not properly applied ULS **or** you really do not
understand all the security concepts, stop right now.

1. Single click on the form in question in the Database Window so it is
highlighted.

2. On the main menu bar go to
Tools | Security | User and Group Permissions

3. The left side will display the Users/Groups and the right side will
display a list of objects. Right now it should a list of your forms and
the one in particular should be highlighted.

4. Click the "List" radio button to show your Groups you have created.

5. Now for each group you do not wish to open this form, simply
uncheck all of the checkboxes in the "Permissions" area below.

6. Hit Apply when all finished.

Now when someone logs into the database *and* they are a member of
one of those denied groups, any attempt to open the form will have
Access generate a message like so "Dude, you're not getting in."
....or some such wording.
 
Sorry for the slow reply, was using Accessmonster and the server shutdown or
something.
Thanks for the Imput I will take your advise and re-modify the design
(Sound alot easier). Just for my own piece of mind (I am a moderate User but
still learning) When I used the article to protect the form was the password
written the module string?? I kinda understand the code, just curious.

Thanks Again for your valuable time.

Larry
 
in message:

Hi Larry,
Sorry for the slow reply, was using Accessmonster and the server shutdown or
something.
Click to expand...

No problem.
No extra points are rewarded for speed.
Thanks for the Imput I will take your advise and re-modify the design
(Sound alot easier). Just for my own piece of mind (I am a moderate User but
still learning) When I used the article to protect the form was the password
written the module string?? I kinda understand the code, just curious.
Click to expand...

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 ("larry")

....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.
Thanks Again for your valuable time.
Click to expand...

No problem, good luck with your project.
 
Back
Top