
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
[ODBC Microsoft Access Driver] Not a valid password.
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.
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
