[RESOLVED] Not a valid password, vb6 access 2003

[longwolf]

I'm using vb6 with an Access 2003 DB
I've already written the app then decided to encode and password protect the DB.

Now I'm getting a 'Not a valid password' error when I use the following code.

    cnT.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
      "Data Source=" & DbPath & ";" & _
      "Jet OLEDB:Database Password=xxXxxX;"
    '(not the actual password, but it follows this format)

    cnT.Open DbPath

I know it has the right password, how do I fix the error?

[longwolf]

Never mind, found the problem.
Should have been....

    cnT.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
      "Data Source=" & DbPath & ";" & _
      "Jet OLEDB:Database Password=xxXxxX;"
    '(not the actual password, but it follows this format)

    cnT.Open