Password

[danon]

Hi every one seaking you're help please
can any one tell me how can i let a user enter and change his \her owne password many thanks

[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

[Dököll]

[QUOTE=Dököll]You could also use the default Log In form by the way, I failed to tell you that... Still need to write code but it should get you started...

[danon]

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

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

[debasisdas]

how you are connectimg to database ?

what are you using ADO or DAO for connection ?

[danon]

how you are connectimg to database ?

what are you using ADO or DAO for connection ?

Hi thanks for the reply

ADOorDAO this is not english to me sorry i dont know what that is
all i know is that i am using visual basic Exprees 2005
thanks again

[Dököll]

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

Greetings, danon! And you're quite welcome...

If you fire up your VB software:

(1) Go to Project right away from your Menu (Don't do File + New Project)
(2) Choose Add form and you will get a pop up
(3) Select the fifth option "Log In Form"

You will get code already written for ya...

If you get this far, you;re on your way:-) You have already established you are running MS Access, that's good enough, we can go through the meaning of ADO or DAO when we go to Access, but for now, tell us if you get Steps 1-3 down, and we shall continue. Please free to wait, as other experts will probably jump in to fill the rest, simple stuff.

Post the code you get when you get it, okay!

In a bit!