[ODBC Microsoft Access Driver] Not a valid password.

[wcilliers]

Hi Experts,

I need help please. I am trying to connect to a MS Access DB via the network. I successfully created an ODBC connection. I am able to see the table structure etc when I select data. But when I reload I get the below error. I did search the forum, and saw that some people suggested using the JET 4.0 driver on OLE DB but this also doesnt work. I cannot make a connection to the DB this way...

Any ideas?

Thanks,

Wynand

Error.......

Started loading data

Connecting to datasource1 (user)

Connected

Connecting to datasource1 (user)

Connected

The following error occurred:

Connector reply error: SQL##f - SqlState: 42000, ErrorCode: 4294965391, ErrorMsg: [Microsoft][ODBC Microsoft Access Driver] Not a valid password.

[wcilliers · Accepted solution]

Hi All,

I managed to get a workaround. I downloaded QlikView on the same machine and set the connection, via standard ODBC after downlading the Microsoft Access database engine redistributable 2010 64bit drivers.

I then switched off Standard Mode in QMC and am now using the exact same connection string in Sense. It is working for now.

Thanks,

Wynand