Password Login

[Newbie!]

Hey does anybody know of anywhere where I can read up or download some
exaples of setting up a multi user password system, using access?

Ta
Si

 

[Newbie!]

Sorry may have not explained correctly ......

I basically have a VB project and want to have the front screen look at a
table in a access database to get the username and then verify the password
from another table.

 

[Armin Zingler]

Sorry may have not explained correctly ......

I basically have a VB project and want to have the front screen look
at a table in a access database to get the username and then verify
the password from another table.

I've never seen a screen looking at something. Apart from this, what exactly
is the problem? How to access a database? (answer:
http://msdn.microsoft.com/library/en-us/cpguide/html/cpconaccessingdatawithadonet.asp)
How to store an encrypted password? (sorry, no answer (I'd look for
'encrypt'))

 

[Cor]

Hi Newbie,

Windowforms or Webforms?

Cor

 

[Newbie!]

windows forms

 

[Cor]

Hi Newbie,

Make a project with two forms

The second form is your dialog in form1 you do in the load event
\\\
dim frm as new form2
if frm.showdialog <> dialogresult.ok then
me.close
exit sub
end if
frm.dispose
////
\\\
In form2 you make two textboxes, and check the name and password against
your database.
if the result is ok you do
\\\
return dialogresult.ok and if not dialogresult.cancel (or whatever)
me.close
////

This is all roughly typed, just ment as a kind of pseudo code.

That is all.
Cor

 

[Newbie!]

Cor i`ve got basically this but its the bit where i select my name and
password from the database that is confusing me, i guess I have to have a
Database connection and a SQL command but im stuck as to what to do.

My database name is Excellence.MDB and I have a table within it called
Users. The Users Table has 3 Feilds in it:

ID - Primary Key, UserName, & Password

Thanks for you help so far, I`ve looked on the NET but carn`t seem to find
anything

Regards
Si

 

[Cor]

Hi Newbie,

Very roughly as I do it.
\\\
Dim conn As OleDb.OleDbConnection = New OleDb.OleDbConnection
conn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=C:\test1\db.mdb;User Id=admin;Password=;"
Dim cmd As New OleDb.OleDbCommand("Select * from tbl1 Where id='" &
txtId.text & "'",conn)
Dim da As OleDb.OleDbDataAdapter = New OleDb.OleDbDataAdapter(cmd)
Dim ds As DataSet = New DataSet
da.Fill(ds)
conn.Close()
(here some encryptingcode)
if myencryptedpassword = ds.tables(0).rows(0).item('mypasword').tostring
then
return dialogresult.ok
else
do something else
end if
////

I hope this helps?

Cor

 

[Herfried K. Wagner [MVP]]

Cor i`ve got basically this but its the bit where i select my name and
password from the database that is confusing me, i guess I have to have a
Database connection and a SQL command but im stuck as to what to do.

Post this question in the ADO.NET group, there you will more likely get
an answer:

<
Web interface:

<http://msdn.microsoft.com/newsgroup...roup=microsoft.public.dotnet.framework.adonet>

 

[Rob Teixeira [MVP]]

Just so we're all clear, the preference is for a one-way transformation on
the passwords (hash rather than reversable block or stream cipher
encryption).
That way, the passwords can never be unencrypted - after all, you only need
to see if they match. That means the password is only in "clear text" in the
user's head and nowhere else (of course we all know the dumb user will
probably tape a sticky note with the password to his monitor...).
Also, a list of hashed passwords can be suseptable to dictionary attacks,
which is why you should also enforce strong passwords (include
caps/lowercase + non-alphanumeric characters, try to avoid common words, and
enforce a decent minimum length).

-Rob Teixeira [MVP]