Visual basic 6 and Login processing

Hi, want to ask the following

if rs.fields(0).value=text1.text and rs.fields(1).value=text2.text then
mainform.show
loginform.hide

As you know, above code is part of Login processing. There are two text boxes for user name and password entry. Number (0) and (1) (in above code) refers to access database fields that user names and passwords are stored there. above code works fine for one user only.

Wondering, how to set for more users and how to extend this code so that anyone whose name,pass is in db, can access to main form. I tried adding fields in db for more usernames but from login form could not refer to them either by field number or data type so, not responding positively.
Thanks in advance