i hav a table named password...with username, staff id and passwords as fields. iv designd a form with user names alrady in using a drop down menu...

how can i get the passwords typed in checkd...and allow staff acess to th database? and if password typed in 3 times wrong...how can i gt the database to shut down?

sum 1 please help me

ths typ uv lngauge drvs evry 1 nts.

If you have a combo box for your user name, hold the password in another, hidden column of this combo. Then you can use code behind your password text box to test the user input against this field.

If you want strong security, use Access own security rather than making your own. To make DIY security really strong needs a good understanding of VBA, which you don't have.