topic Re: error by password protected accdb-file in Talend Studio

error by password protected accdb-file

CBgt — Mon, 10 Oct 2016 09:15:02 GMT

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

Re: error by password protected accdb-file

Anonymous — Mon, 17 Oct 2016 10:47:17 GMT

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

Re: error by password protected accdb-file

CBgt — Tue, 18 Oct 2016 07:47:25 GMT

That's a pity!
Thanks for the answer

Re: error by password protected accdb-file

Anonymous — Wed, 19 Oct 2016 09:34:59 GMT

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