By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,224 Members | 1,143 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,224 IT Pros & Developers. It's quick & easy.

most efficen way to set up a log in screen

P: 18
i want to set up a log in screen...where people could log in into the database. to do this...i should have a switchboard where i have username and password and log in and exit button

------------------------------------------------------

USERNAME: [------------------------] <---text box
PASSWORD: [*******************] <----text box

[ EXIT] [LOGIN]

-----------------------------------------------------

so then i should have a table where there is list of username and password....so my question would be..how do i get it to check the inputs with the table and then...depending on the username and password entered what privilates they get what they see and what they dont see.

list of account should be
ADMIN (full access to everything, from chaning forms all the way to enabling options)
and then staff (just to adding simple records here and there but each should hae no access to other access filing)

so then there must be multi (if thats the case) switchboards. and i would to have somewhere record who has loged in and when..

i am using MS ACCESS 2007

and if this requeris VB then just let me know....i done vb before but way to long ago..so i might need very clear instruction on how to do this.....

thank you alll for reading this.
Aug 15 '07 #1
Share this Question
Share on Google+
1 Reply


Stang02GT
Expert 100+
P: 1,208
i want to set up a log in screen...where people could log in into the database. to do this...i should have a switchboard where i have username and password and log in and exit button

------------------------------------------------------

USERNAME: [------------------------] <---text box
PASSWORD: [*******************] <----text box

[ EXIT] [LOGIN]

-----------------------------------------------------

so then i should have a table where there is list of username and password....so my question would be..how do i get it to check the inputs with the table and then...depending on the username and password entered what privilates they get what they see and what they dont see.

list of account should be
ADMIN (full access to everything, from chaning forms all the way to enabling options)
and then staff (just to adding simple records here and there but each should hae no access to other access filing)

so then there must be multi (if thats the case) switchboards. and i would to have somewhere record who has loged in and when..

i am using MS ACCESS 2007

and if this requeris VB then just let me know....i done vb before but way to long ago..so i might need very clear instruction on how to do this.....

thank you alll for reading this.

I have provided a link that shows you exactly how to make a log in screen step by step.


Click Here


good luck and if you need anything else just ask :)
Aug 15 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.