I'm hoping your problem is within the syntax on your connection open.
This is my trick for quickly getting the correct syntax on connection strings:

within a VB6 open up the Data View window
create a connection object
Use the property pages of the connection object to select your provider,database
name, username and password.
Test out if the connection is successful.
Click OK to close the Property Pages.
Visit the properties window for this new connection.
Cut all text out of the "ConnectionSource" property.
This string is exactly what you need to give to the cnn.Open
Edit in your varnames - mstrDb..etc

"Andrew" <> wrote:
>Hello all,
>The following line has always worked fine...
> cnn.Open "PROVIDER=Microsoft.Jet.OLEDB.4.0;Data Source=" & mstrDB & ";"
>...until I made the mistake wanting to learn how to password protect my

>database. All I did was run Wrkgadm.exe and click join. (Mind you, this
>is what the Access help said to do). Then I went into one of my databases
>and changed the admin user's password to "test". After trying it out to
>see how it worked, I changed it back to blank. Now, none of my applications
>can open any of my databases.
>I keep getting the insightful message:
> Run-time error: '-2147418113 (8000ffff)':
> Catastrophic failure
>I must say that I am extremely happy to be informed of this, but what does
>it mean? Obviouosly, something to do with users and passwords. I tried
>to change everything back to the way it was. What did I miss?
>Please help...
>Thank in advance.