MS Access Invalid password. Bug?
InoLMay 13 2011 — edited May 13 2011I am trying to use the migration wizard for MS Access in 3.0.4. When trying to connect to a password protected mdb file I get this error
[Microsoft][ODBC Microsoft Access Driver] Not a valid password
(and I am sure the password is correct, because I can connect using MSAccess with this password)
I have a strong feeling that the password is not included in the connect string, because this is what is shown in the Connection Details:
@jdbc:odbc:Driver={Microsoft Access Driver (*.mdb, *.accdb)};DBQ=D:\Release\Release804.mdb;DriverID=22;READONLY=false}
It also looks very much like a similar bug in MySQL that I found here:
http://bugs.mysql.com/bug.php?id=37449
Is this a bug, or am I missing something?
To add: I have used this before on a 2.something SQL Developer without problems.
For now I have removed the password in the Access database, which was a challenge by itself. After opening the database normally I didn't see any toolbars at all. Apparently you must shift-click the OK button after entering the password. Might be useful for someone else to know this.
B-)
Edited by: InoL on May 13, 2011 12:51 PM