Help!!!

J

JNariss

Hello,

In my database I have created a form which I only want to allow certain
people to open up and fill out.

I thought that by creating a table called "Code" with a password in one
of the fields will give me the ability to somehow do this. But now I am
stuck.

So far..............I created a table and called it Code and added one
record to it with the word: snow.

I created a custom form dialog box which says: please enter the code
below

I want the user to enter the word "snow" and once they click the ok
button the form will appear. However if the word "snow" is not entered
or another word is entered I want a message box to appear saying "You
must enter the correct code"

Is there a way to do this and how?

Thanks,
Justine
 
R

Rick B

Access includes a built-in User-Level Security system to allow you to create
userid and passwords then to assign specific privileges to every object in
your database.

Don't reinvent the wheel, use the tools available. Using your home-grown
security has tons of holes. What keeps the user from simply opening the
table and bypassing your form altogether? What prevents them from going
into design view and reading your code?

Read and reread the following links, make a backup copy of your files, then
follow every step in order.


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
 
J

JNariss

Rick-

I really appreciate your quick response. However, here is the problem:
I don't have the time to set up security right now. My boss's boss
needs this done today by 3 and I don't really have the time to set up
each users security. So that is why we came up with the code dialog
box. I will eventually set up security but right now we just need it on
this one form.

Thanks,
Justine
 
R

Rick B

If it is temporary and you know it will not be very secure, then just get
rid of the table and do it all in code.

Set the form or file to locked.

Ask the user to enter the password.

If the password equals snow, unlock the form.

Otherwise, loop.
 
R

Rick B

Or just build TWO userIDs for the moment. One that has access to the form,
and one that does not.

Then, later go back and add the rest of your users.
 
J

JNariss

Thanks Rick,

I will try to do the lock form method. I really appreciate all your
help.

Justine
 
Top