Password

Originally Posted by Dököll

Hey there!

If you want simplicity, I think I can help you...

You could build a database that'll hold the credentials for which each visitor will use:

(1) You can either have visitors add the credentials (usernames and passwords) in by accessing your admin part of the database

(2) Or you can give users specific passwords which they'll need to change upon accessing your login page

(3) Or you could go crazy and access Active Directory through VB, if you are doing this on a network.

I would build a simpe MS Access database and start there:

(a) Build a database, called Accounts
(b) In it add a table called Users
(c) Add four fields, ID, UserName, Password, TimeStamp

Note, ID should be set to AutoNumber in your database, and TimeStamp to Date, and should be defaulted to Now(), so time loads the moment visitors to your site/software access the database table called Users.

Now on to VB, you will need two forms in my opinion, assuming you know a bit of VB:

(1) Run VB, make a new project, project1, form1 by default loads, you can keep as is if you want just to test it out

(2) Drag two textboxes, namely Text1, Text2 onto form1, no change there either

(3) Add a command button, leave it as is for now, nothing fancy

The whole idea is your visitors will use that form to submit their passwords to the MS Access database back-end... You're going to need to perhaps run an SQL query to return a recordset of two columns and possibly, and if found, allow user in to other secure forms/sites

(a) Do a search on ADO/DAO Recordset throught this forum
(b) You may also need ADODB
(c) Also do run a search under ADODC1, see what comes up

Please stay tuned, and keep searching if this is not what you needed.

Good luck!

Dököll

Originally Posted by debasisdas

how you are connectimg to database ?

what are you using ADO or DAO for connection ?

Originally Posted by danon

HI to you Dököll
first of all i would ilke to thank you for you're reply and i just want to say that iam new to vb and new to programming but with the books i have
you know its not mach you can learn but i am very pleased with you're answer
i am using an acsee instead of SQL unless you think is better to use SQL
and i'll try to learn it

1 this is some thing that i am stack with ( SEARCH )
how can i search exp a client deitals of course they are stored in the ACCESS database using a text box to wright the -exp- name or ID and a button to excute the search
i'll be gratful to you if you can help me with this

MANY THANKS
regard rush