I just use one user 'default' and have a that user be used to access the username table which contains the passwords and user neame.
I say::
appCode().sqlsvr(127.0.0.1,default,**password**,sq lString)
then::
('select * from users where username=' & txtusername.text.tostring & "'")
So just have one user that has a all the user information inside the database, you'll find that the easist way of doing it. If you want the appCode() I use to access
sql simple and fast just PM me, also I can help you in a lot of ways with
SQL, eg shortcuts.