Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
cancel
Showing results for 
Search instead for 
Did you mean: 
CBgt
Contributor
Contributor

error by password protected accdb-file

Hi,
I just tried to open an Access 2010 accdb file which is encrypted (password protected).
I created a database connection with the access data type Access to an accdb file.
The following error occurred during the test
java.lang.RuntimeException: net.ucanaccess.jdbc.UcanaccessSQLException: Decoding not supported.  Please choose a CodecProvider which supports reading the current database encoding.

I am working with java version "1.8.0_91" and
Talend Open Studio 6.0 and Talend Open Studio 6.2
with modules

jackcess
jackcess-encrypt
ucanaccess
apache commons-codec
hsqldb
What can I do? Without password I can access the database.
Best regards
Labels (4)
3 Replies
Anonymous
Not applicable

Hi,
So far, we can not use tAccessInput to extract data from a password protected file.
Best regards
Sabrina
CBgt
Contributor
Contributor
Author

That's a pity!
Thanks for the answer
Anonymous
Not applicable

Hi,
 tAccessInput component should be possible to open an Access 2010 accdb file if you can open the password protected access file in read-only.
Best regards
Sabrina