[RESOLVED] Not a valid password, vb6 access 2003
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.
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?
Re: Not a valid password, vb6 access 2003
Never mind, found the problem.
Should have been....
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