Logging In Form

[Chyld]

Hi All.

Since I can't get the 'extract computer name' working, I'll have to settle for the old faithful login screen.

How do I set up a login screen that checks to see whether the users name and password are correct then allows them to move on to the main form?

I can do the codey bit but I don't want it like this:

if me.username.text = "mongoose" and me.password.text = "horsecack" then msgbox "Username and Password successful"
else: msgbox "Sorry, you are a lamer and shouldn't be accessing this database!"
end if

end sub

blah blah, I know the language is a bit pants, but someone a little brighter than me could get into the system and look up all the usernames and passwords and abuse my creation.

I have seen it done with a table of usernames and corresponding passwords but don't know how to do this just yet? Maybe I should try the 'computer name' again!! Bummer...

Chyld

 

[tlbroadbent]

Have you read up on Access security? It provides a login screen. You can limit access to only thoses database objects a user or group of users should be able to view, update, execute, etc. The following link takes you to a FAQ that explains, step by step, how to set up security.

Access Security FAQ from Microsoft

http://support.microsoft.com/support/Access/Content/SECFAQ.asp

Terry Broadbent

"The greatest obstacle to discovery is not ignorance -- it is the illusion of knowledge." - Daniel J Boorstin

 

[Chyld]

Yeah, I've used it before with the logging in screens etc and setting up user types and accounts, but I hated it. Anyone who knew passwords could get in anyway etc.. I'm wanting to learn alot about the processes and would appreciate help on the above.

Basically I'd like to make my own login screen!

Chyld