Unfortunate I'm currently not able to setup or test this myself. I can only give you some pointers...

So you say you don't get an error with the "objConnection.Open strConnection" command when you execute this against a password protected database? And what if you query for example for a list of tables within this "objConnection" object? Will the result of that give you something to conclude if you are querying against a password protected database?

You need to do something within the ADODB object to see if you are accessing a password protected database or not. After that you only proceed to open the database with "OpenCurrentDatabase" if it is not password protected.