login

[herb]

im writing an application that requires a user to login with username and
password and the system would check it again the access database. i'm also
using oledb connection to connect to the database and i'm not getting any
rows back where i do a select statement to check the username and password.

"select * from user where username = '" & txtusername.text & "' and password
= '" & txtpassword.text & "'"

[Greg Low [MVP]]

Hi Herb,

To make sure your connection is working, can you read other tables?

Regards,

--
Greg Low [MVP]
MSDE Manager SQL Tools
www.whitebearconsulting.com
PS: Can I suggest you also take a look at articles on sql injection attacks?
The code you are writing is very likely to suffer from these.

"herb" <he**@discussions.microsoft.com> wrote in message
news:68**********************************@microsof t.com...

im writing an application that requires a user to login with username and
password and the system would check it again the access database. i'm also using oledb connection to connect to the database and i'm not getting any
rows back where i do a select statement to check the username and password.
"select * from user where username = '" & txtusername.text & "' and password = '" & txtpassword.text & "'"

[Ken Tucker [MVP]]

Hi,

First off you should encrypt a password before you save it. Second
the reason you are not returning any rows is that either the password or
username is wrong.

http://msdn.microsoft.com/msdnmag/is...a/default.aspx

Ken
----------------------
"herb" <he**@discussions.microsoft.com> wrote in message
news:68**********************************@microsof t.com...
im writing an application that requires a user to login with username and
password and the system would check it again the access database. i'm also
using oledb connection to connect to the database and i'm not getting any
rows back where i do a select statement to check the username and password.

"select * from user where username = '" & txtusername.text & "' and password
= '" & txtpassword.text & "'"