password protected form

[ariansman]

Is it possible to make a form protected by password?
Thank you

 

[Mr. B]

This is one of those "do it yourself" projects. Implementing something like this depends on just how "secure" the requirements are. If you only need to have the user supply some basic password to gain access to the form then just create another form and have that form promt the user for the password. You can then use VBA code or even a macro to check to see if the correct one has been provided and if so, open the protected form and close the prompting form. If the correct password is not provided, just inform the user and do not open the protected form.

 

[ariansman]

Thank you very much,
The form is to put some information into a table. I want it to prompt the user for a password and/or username. But I don’t know how can i design such a form, neither I know anything about VB. Your help is appreciated.
Thank you.

 

[Mr. B]

I would suggest that you start by creating a form that will allow you and your users to input the data to your table. Once you have that working you will have learned much more about Access and developing forms.

Once you have that experience under your belt, then you can create another form that will provide a place for the user to input their user name and passwork, have that form be presented first and then when they have entered their user name and password, have a command button on that form that when clicked would use a macro (or VBA code) to open the form for the data input.

Just my suggestion.

 

[ariansman]

Thank you very much,
well, I have already made a table to input the data. But I specifically don’t know how to make the other form to prompt user for a username and password. in other words, I know how to make a form in different ways, but I don’t know how to make a form ask the user for a username and password.
Regards,
[FONT=&quot][/FONT]

 

[ariansman]

can anyone solve this problem?

 

[Mr. B]

Create an unbound form. Have a couple of text boxes (one for the username and one for the password). Create a couple of command buttons. One to be a Cancel button to allow the user to abandon the login in process. The other would be the "login" button and would be disabled until the user has provided the username and password.

Then you can use VBA code in the On Cllick event of the command button to check the values provided by the user against the value stored in you table and if they match, present some other form to the user, if they do not match inform the user with a message box and return them to the login form.

I hope this will help you get going on your project.

Most of the folk here on the form have no problem trying to help, however, i will be easier to try to help you if you ask specific questions. As you start trying to create your form, when you run into a problem you can solve, just post back here or maybe try Google. Google is my best buddy. LOL

 

[ariansman]

Thank you,
I made one table named: Check. It has these fields: ID, username, password, and records: 1,jack,1234 2,james,3245 , 3, amanda, 7654
I made a form named login. I put two unbound text boxes named "user" and "pass".
Then I put a command button , and used macro builder. Unfortunately it is not working. I hope i was on a right track so far. obviously i failed on VBA part. I wonder if you can help me on how to make the VBA code that I should use to make it working.
Thank you

 

[Mr. B]

If you can attach your database, I will take a look as see what needs to be done.

 

[ariansman]

thank you for your time,
please get the file from the following link.
http://rospina.com/passprotected.accdb
i want the form loging check for the username and pass to match and then the user will be able to open the other form, employees, to insert the data.

 

[pwbrown]

Will different users be using the form with different usernames and passwords?
It is possible to just create a pop-up asking for a password to open a form, then you don't have to create a new password form. It depends on your needs.
Here is a good example posted by khawar:
http://www.access-programmers.co.uk/forums/showpost.php?p=737223&postcount=2

 

[Mr. B]

ariansman,

Take a look at this modified version of your database.

I made serveral changes. Some were strickly for "best practice purposes" while others were to meet requirements.

First just open the attached file. You will be presented with the modified "Login" form. Enter "Jack" as the Username and "1234" as the password. Click the "Submit" button and you should see your existing Employees form. This form has been renamed as "frmEmployeer". Your tables have aslo been renamed to include the "tbl" prefix. Just a naming convention thing with me.

To get into the database in normal design mode, just hold down the shift key while opening the file.

I have VBA code on the On Click event of the Submit and Cancel buttons.

As you have questions just post back.

 

[ariansman]

Thank you very much for you time,
Well I have three questions,
1- It worked with jack, 1234. But it seems it can be logged in with any other name and password. check JOJOBA, 567654.
2- How can we design it so that after jack logs in with his user/pass, all data are entered by his name. In other word we will be able to know which user has entered what specific data.
3- I am now really worried about a security leak. I used to go to “access options/current data base” and remove the check boxes from “display navigation pane” and “allow full menu” and then guide the user through a panel into different already designed forms and reports. Now it seems by simply holding down the SHIFT key the user will see the heart of database and will be able to change data. Is there a way to totally make access a secure and blocked database?
Regards

 

[Mr. B]

Please take a look at this modified version of the database.

1- It worked with jack, 1234. But it seems it can be logged in with any other name and password. check JOJOBA, 567654.

I did not fully test the conditions and had to make changes to how the user input is being evaluated. It now works as expected, requiring the correct combination of Username and Password.

2- How can we design it so that after jack logs in with his user/pass, all data are entered by his name. In other word we will be able to know which user has entered what specific data.

You will need to add a field or two to your existing table and then be sure to manually, using code, update these fields when the user add or updates records. These fields would be UserID and CreateDate and/or ModifiedDate or both.

3- I am now really worried about a security leak. I used to go to “access options/current data base” and remove the check boxes from “display navigation pane” and “allow full menu” and then guide the user through a panel into different already designed forms and reports. Now it seems by simply holding down the SHIFT key the user will see the heart of database and will be able to change data. Is there a way to totally make access a secure and blocked database?

You would need to design a good user interface. There is a way to use code to disable the use of the Shift key when openiing the database. There are several other things that you will want to consider when distributing your database. I would suggest that you consentrate on getting the design of your tables correct for your database, and then creating the user interface. Then when you are ready to have users use it, you can post back asking specific questions about how to accomplish what you need.

Sorry, but is is impossible to provide all of the answers you need at one time. Take things one at a time and work out the issues.

 

[ariansman]

thank you very much,
your guide was really help full,
i will post specific questions later
best regards