Menu

Open an encrypted access db

Help
Matias
2014-11-25
2014-11-25
  • Matias

    Matias - 2014-11-25

    Hello, i was wondering if someone could help me to access an encrypted access database.
    currently i'm using "ucanaccess-2.0.9.2.jar".
    i tried to connect to db using the following codes:

    Class.forName("net.ucanaccess.jdbc.UcanaccessDriver");
    conn = DriverManager.getConnection("jdbc:ucanaccess://db/db.accdb;password=myPassword");

    But i'm getting this exception

    net.ucanaccess.jdbc.UcanaccessSQLException: Decoding not supported. Please choose a CodecProvider which supports reading the current database encoding.
    at net.ucanaccess.jdbc.UcanaccessDriver.connect(UcanaccessDriver.java:210)
    at java.sql.DriverManager.getConnection(Unknown Source)
    at java.sql.DriverManager.getConnection(Unknown Source)

    I hope someone can help me as soon as possible.
    Thanks. :)

     
  • Marco Amadei

    Marco Amadei - 2014-11-25

    You have to follow all the steps mentioned int the ucanaccess website, tab "getting started", about the connection parameter "JackcessOpener" and so about the integration with jackcess-encrypt and all related dependencies.
    Cheers Marco

     

Log in to post a comment.