VBA/ADODB: to pop-up message box if userID & password in Access database didn't match

[hydz1213]

Hi everyone!

I have a userform in Excel with VBA code that connects to Access database. The code below simply selects certain details from database & populate the label objects once the userID and password matched.

But what I also want is to just simply pop-up a message box if the userID & password supplied in the userform DID NOT match. I can't seem to find a solution to this simple action that I need. I'm hoping somebody could help.

Thanks,
hydz1213

Please Login or Register  to view this content.

[Kyle123]

You need to check if the recordset is empty, so if BOF = TRUE and EOF = TRUE then the password is incorrect since there are no rows returned.

P.S I really hope you aren't storing passwords in plain text

[hydz1213]

Hi Kyle123,

Thank you so much for your response. The passwords are actually alphanumeric characters which I hope is not the reason why I can't still seem to get this message box to pop-up work.

I tried revising the code with this, but nothing happens if userID & password is not a match.

Please Login or Register  to view this content.

Please correct me! I'm really new in ADODB.

Thanks again,
hydz1213

[hydz1213]

With this code, it now does work! Message box pops-up when userID & password is not a match. However, if found a match, it DOES NOT retrieve data anymore!

I'm really confused!

Please Login or Register  to view this content.

[Kyle123]

You need to check whether the recordset is empty BEFORE trying to loop through it:

Please Login or Register  to view this content.

[hydz1213]

Hi Kyle123

Sorry for very late reply. But your code worked already!!!

Thank you so much for your clarification. I'm still learning the ADODB syntax.