View Single Post
  #4 (permalink)  
Old May 23rd, 2008, 02:58 PM
BrianWren BrianWren is offline
Friend of Wrox
 
Join Date: Nov 2004
Location: Port Orchard, WA, USA.
Posts: 1,621
Thanks: 1
Thanked 3 Times in 3 Posts
Default

Create a table in Access, holding the login info. (You might want to build your own encryption routine to make these values hard to decypher.)
When a user logs in (that is, fills in a username and password textbox), try to open a recordset on that table
Code:
...
"WHERE USERNAME = """ & UName.Text & """ " & _
"  AND PASSWORD = """ & PWord.Text & """"
If the recordset is empty, they don't get logged in.
Reply With Quote