Click here to Skip to main content
15,896,912 members
Home / Discussions / Database
   

Database

 
AnswerRe: Help! our DBA died Pin
Mike Dimmick1-Nov-05 1:59
Mike Dimmick1-Nov-05 1:59 
GeneralRe: Help! our DBA died Pin
sameerhanda2-Nov-05 3:35
sameerhanda2-Nov-05 3:35 
GeneralRe: Help! our DBA died Pin
rwestgraham2-Nov-05 11:34
rwestgraham2-Nov-05 11:34 
GeneralRe: Help! our DBA died Pin
sameerhanda3-Nov-05 4:24
sameerhanda3-Nov-05 4:24 
QuestionXML to SQL Server data transformation Pin
Probal Roy31-Oct-05 2:12
Probal Roy31-Oct-05 2:12 
QuestionSQL - Check if field contains string Pin
Zanathel30-Oct-05 7:07
Zanathel30-Oct-05 7:07 
AnswerRe: SQL - Check if field contains string Pin
toxcct30-Oct-05 8:12
toxcct30-Oct-05 8:12 
GeneralRe: SQL - Check if field contains string Pin
Zanathel30-Oct-05 11:15
Zanathel30-Oct-05 11:15 
GeneralRe: SQL - Check if field contains string Pin
toxcct30-Oct-05 20:58
toxcct30-Oct-05 20:58 
GeneralRe: SQL - Check if field contains string Pin
Leather992-Nov-05 3:30
Leather992-Nov-05 3:30 
QuestionmySql in my application Pin
Sasuko29-Oct-05 14:01
Sasuko29-Oct-05 14:01 
AnswerRe: mySql in my application Pin
Paul Conrad30-Oct-05 18:36
professionalPaul Conrad30-Oct-05 18:36 
GeneralRe: mySql in my application Pin
Sasuko30-Oct-05 21:30
Sasuko30-Oct-05 21:30 
GeneralRe: mySql in my application Pin
Paul Conrad31-Oct-05 4:54
professionalPaul Conrad31-Oct-05 4:54 
QuestionORDER BY @Variable??? Pin
Carl Mercier29-Oct-05 10:43
Carl Mercier29-Oct-05 10:43 
AnswerRe: ORDER BY @Variable??? Pin
twostepted30-Oct-05 17:39
twostepted30-Oct-05 17:39 
GeneralRe: ORDER BY @Variable??? Pin
Carl Mercier30-Oct-05 19:19
Carl Mercier30-Oct-05 19:19 
GeneralRe: ORDER BY @Variable??? Pin
twostepted31-Oct-05 12:56
twostepted31-Oct-05 12:56 
AnswerRe: ORDER BY @Variable??? Pin
Edbert P31-Oct-05 12:20
Edbert P31-Oct-05 12:20 
QuestionOptimization - newbie problem Pin
gbaii29-Oct-05 0:36
gbaii29-Oct-05 0:36 
AnswerRe: Optimization - newbie problem Pin
Edbert P31-Oct-05 12:28
Edbert P31-Oct-05 12:28 
Aside from a note that you should try using parameters instead of concatenating your SQL statements, the only optimization I can see is this:
Set rst = qdef1.OpenRecordset()
If rst.EOF Then
   MsgBox "Not Found"
   Exit Sub
Else
   MsgBox "Found. Do whatever you want"
End If

First, your SQL statement will not work as you're concatenating the apostrophe with the and operand, see: username= '" & [Forms]![form1]![input_user] & "'" & "and userpass=. You should put a space before the and operand.

Second, your SQL statement will only return a record(s) that have the same username AND userpass, therefore it will not be able to tell if there are no records returned whether it is because the username does not exist or the password is wrong. You do not want to tell users whether it is the password or the username that is wrong. Just tell them username or password is invalid.

Does that help?

Edbert P.
Sydney, Australia
GeneralRe: Optimization - newbie problem Pin
gbaii1-Nov-05 7:31
gbaii1-Nov-05 7:31 
QuestionMessage for Vijay Mathew Pandyalakal re Easy_odbc Pin
mville28-Oct-05 21:02
mville28-Oct-05 21:02 
Questionconnect to remote oracle Database Pin
odukuye28-Oct-05 10:40
odukuye28-Oct-05 10:40 
QuestionADV ICE WANTED!! Pin
jaygreen928-Oct-05 8:59
jaygreen928-Oct-05 8:59 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.