How to create a User Login Form in Microsoft Access
Answer » The following details one procedure that could be applied to this scenario. There are many more approaches to this and also other areas that will need to be secured within your database environment. You should also look into Disabling/Enabling the Shift Bypass Key.
Thank you for taking the time to report an issue.
What's wrong... Please write below.
I am hung up on how to get the login information to transfer over to the form. Here is the code that controls the login process;
All I need is the username. And then I need it to autopopulate a field in a form.
For some reason, but now the Login screen does not close properly.
Here is my code for the Login botton of the Login screen.
What Happen? - I created a login form, where a user enters the login details. It was working fine and I loaded the login form as the form to open when access starts. Each time I open the DB I can see access 2007 popping up before the login form shows, also the background appears.
I was trying to get rid of the background and the access 2007 start screen. I just wanted the login form to show. I then changed the following controls:
Allow Add. = No
Allow Del. = No
Allow Edits = No
Allow Filters = No
Data Entry = No
I saved the form and THEN.
When I started the DB, it do not do the required results and it would not allow me to enter the user details to login. all this said, I cannot access the db to change.
SOmetime back I result some DAO process where you can access another database and not the current one. I would like to do similar code to reset the password on the useraccess table so whenI start my data base it will access a blank password.
The problem is when I try to create the exact same login, in my actual database, for some reason it does not work. I checked all the names and so on but cannot seem to get it to work.
Is there a different built in function that will pull the computer login information rather than the DB access login.
When I use (Current User) now it simply enters Admin in the field since no user login information is in the new database.
So, after the application is done, it can be used like that: 1. Give the accdb file to the 1st user. The user can use the login form to find his/her records in a main form (that is bound to a main table used to collect data), and then modify existingrecords or add new records at the end of the main form.
2. Give the accdb file to the 2nd user. The user can use the login form to find his/her records, and then modify existing records or add new records.
3. . (next user)
I have a form and a table login(user, password, role)where user can login with username and password by referring to Login table.
How can I view the role in MsgBox according to username and password in table login? I'm having trouble in here (Underline words). The Logic is if username and password has been filled and then search in table. If Its TRUE then it will show MsgBox with the role user in table Login.
Or do you have any better codes for this?
I.e. Hire Manager can only access hire employees, accounts manager can only access accounts employees etc.
I have all the employees in one table called tblEmployees. Each record has a field called 'location' which shows which department they are in.
I have a table called tblUsers with User Names and passwords. I have also created a simple user login form with the following code beind a login button.
The code works fine as a login prompt but I need help with restricting access to certain records within the employees table.
I also need to block access to any tables/queries etc for users until logged in. Currently users can avoid the login form and access/