467,921 Members | 1,350 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 467,921 developers. It's quick & easy.

VB6, code refer to access database

Bit
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
1 Week Ago #1
  • viewed: 1132
Share:

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

3 posts views Thread by blantz | last post: by
7 posts views Thread by Allison | last post: by
9 posts views Thread by Wayne Smith | last post: by
4 posts views Thread by Tony | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.