Yesterday I was finally able to create a test case of my own. The code I provided in the previous post is tested by me.

Initially I just used the code "objConn.Open strConnect". This did indeed default pop-up with the password-mismatch message. But when I also used the code "On Error Resume Next" it didn't pop-up anymore and the process continued to the "if err.number" block, so I could display my own message box.

Please let me know your results...