Access database encoding

Daniel shared this question 4 months ago
Answered

Hello

I am trying to create an acceee database as a data source, in accdb format I use ucanaccess, as specified in this post:

https://community.yellowfinbi.com/knowledge-base/article/how-to-use-ucanaccess-to-connect-to-access-databases-using-jdbc-only

However, I get the following error when trying to connect: com.healthmarketscience.jackcess.impl.UnsupportedCodecException: Decoding not supported. Please choose a CodecProvider which supports reading the current database encoding

Regards!

Comments (5)

photo
1

Hi Daniel,

Thank you for reaching out to us on this. Based on the error which is coming directly from the JDBC driver, it suggests that this database is encrypted. The following comes directly from the UCanAccess site (https://jackcess.sourceforge.io/faq.html#encoding)

This exception indicates that the Access database you are attempting to open is "encrypted" using one of the various forms of encryption utilized by Microsoft. Due to various constraints, the Jackcess project does not directly support decrypting Access databases, but does, however, support plugging in encryption support using a custom CodecProvider. The separate Jackcess Encrypt project contains the CryptCodecProvider, which implements the Jackess CodecProvider interface and supports some forms of Access database encryption.
Having looked into the encryption provider I am not sure this will be able to be added without creating your own jdbc extension, so I would recommend removing the password from the Access database file and testing again to see if this works.

Cheers,

Neal

photo
1

Hello, thanks for the answer

Ok, I have done the test without password and it works fine.

Now I have a second problem. How can I create the data source if the access database is in an ftp location (with username and password)?


Regards!

photo
1

Hi Daniel,

Glad my suggestion worked for you. Unfortunately I do not know if that will be possible or not, though I would be inclined to say that you probably will not be able to do this. You would need to reach out to the UCanAccess community to see if anyone has experience in using this over FTP. I had a quick test and it does not look like their driver supports the use of the ":" character which would be required to specify an FTP port (or the ftp protocol itself), so I do not think this is possible, but the wider UCanAccess community may be able to help.

Was there any other questions you had?

Cheers,

Neal

photo
1

Hello!

No, thanks for Everything!

photo
1

Hi Daniel,

Always happy to help.

Cheers,

Neal