Hi 
First off, i am a complete novice in this area, so be kind
I’m currently doing a Bsc in Computing, and we have a database module ( my worst subject
) the current assignment is to create a DB for a specific task, and one of the objectives is to create a login page for the DB . I tired to use Access's built in 'user and permissions wizard' but had no luck there.
I have a staff table, and linked that to a permissions table, I assigned each member of staff a user level (5 levels in all). I then created queries to filter each of the 5 levels, and used parameters in each of the 5 queries to prompt for a username and password. I then created a form for each of the queries. i then tested each of the forms, and it asked for the username and password, and I was in, I thought my idea had worked, however, if I enter I wrong username or password, the form will still appear .
I’m wondering if there is a way to validate the query parameters? or is there an easier way I can do this? I know i am probably going about this in completely the wrong way. All I need is a main login page, which will offer each user a different GUI.
Any advice will be greatly appreciated. As aforementioned, this is not my best area, and this is the first time I have actually used access.
Thank you in advance
*Edit
I have searched th eforums, and cannot seem to fidn anythign on parameter validation, but did find a lot of ways to code a login page. i do not want to do this so i will stick with using access's built in users and permissions. I know that to login you need to click the shortcut that is created, but if i take my DB elsewhere how can i get that login page to be displayed? becuase if you click directly it will nto let you in , u need to click the shortcut, so how could i get around that?? thank you
First off, i am a complete novice in this area, so be kind
I’m currently doing a Bsc in Computing, and we have a database module ( my worst subject
) the current assignment is to create a DB for a specific task, and one of the objectives is to create a login page for the DB . I tired to use Access's built in 'user and permissions wizard' but had no luck there.I have a staff table, and linked that to a permissions table, I assigned each member of staff a user level (5 levels in all). I then created queries to filter each of the 5 levels, and used parameters in each of the 5 queries to prompt for a username and password. I then created a form for each of the queries. i then tested each of the forms, and it asked for the username and password, and I was in, I thought my idea had worked, however, if I enter I wrong username or password, the form will still appear
.I’m wondering if there is a way to validate the query parameters? or is there an easier way I can do this? I know i am probably going about this in completely the wrong way. All I need is a main login page, which will offer each user a different GUI.
Any advice will be greatly appreciated. As aforementioned, this is not my best area, and this is the first time I have actually used access
.Thank you in advance
*Edit
I have searched th eforums, and cannot seem to fidn anythign on parameter validation, but did find a lot of ways to code a login page. i do not want to do this so i will stick with using access's built in users and permissions. I know that to login you need to click the shortcut that is created, but if i take my DB elsewhere how can i get that login page to be displayed? becuase if you click directly it will nto let you in , u need to click the shortcut, so how could i get around that?? thank you
Last edited:
