Password/Security 1

[BT24]

Hello

What i would like to do is to have a simple password system on my database, is it as easy as having a query with all the passwords in it and criteria based on that. i would like it to start on open, but i really dont know where to get started. thanks for all the help

IAMUSELESS

 

[snoopy75]

Not very secure, but definitely simple! Okay, so make a table called tblUsers with two text fields: Username and Password. Make an unbound form with two text boxes (named txtUsername and txtPassword) and a command button. In the Properties of the command button, set the OnClick event to [Event Procedure] and click the "..." button next to it. Paste the following code:

If DLookup("[Password]", "tblUsers", _
   "[Username]='" & Me![txtUsername] & "'") = Me![txtPassword] Then
     DoCmd.Close
     DoCmd.OpenForm "frmSwitchboard"
Else
     MsgBox "Wrong!!!"
     Application.Quit
End If

Save the form. Call it something like frmLogin. Then go through the menus to Tools -> Startup and set the "Display Form" box to the name of your form. And you can uncheck "Display Database Window" to make it look really cool.
I haven't tested this, but I think it's okay. If it doesn't work, let me know, and I'll get it right.

--Ryan

 

[BT24]

Thanks Ryan

what is happening is frmLogin is coming up on Open but when i hit the button there is nothing happening. the switchboard is not opening. also where will i add the Usernames and passwords? will i add them to the table? thanks again
IAMUSELESS

 

[thornmastr]

What you are asking for is a password on your database. Why should you do something that Access will do for you. Click on security, click on database password. You've done it. Robert Berman
Data Base consultant
Vulcan Software Services
thornmastr@yahoo.com

 

[BT24]

I Got it thanks for all the help

IAMUSELESS

 

[snoopy75]

LOL I guess spending all day figuring out complex problems makes one overlook the obvious solutions sometimes.

 

[thornmastr]

Can you think of a better way to learn your craft? Robert Berman
Data Base consultant
Vulcan Software Services
thornmastr@yahoo.com