Add password protection to the application

[dealwi8me]

I' ve created an access appliaction and i want when user run the application to see only the username/password form (with no menus,toolbars,etc).

After he inserts the correct username/password,he will be able to see the menus. If he inserts the wrong username/password he will get an error message and go back to the username/password form.

Any suggestions how to do that?

Thank you in advance.

 

[checoturco]

hi,

you can put the form with the login/password on tools->startup, this form has this code:
password="123456"
word=inputbox("password")
if word<>password then
msgbox " password incorrect "
else

docmd.open <main_menu>
end if

 

[dealwi8me]

docmd.open <main_menu>

what do you mean by this line?

When i say main menu i mean a toolbar menu, not a form.
Is it possible to activate a toolbar through a form?

 

[checoturco]

well, i thought that you wanna open a form if the pwd is correct...

 

[GaryPanic]

if you look through some of the sample databases - their is password screens - and these are pretty good -