0

I want to open an encrypted MS ACCESS (.accdb) database in Squirrel SQL Client Version 4.5.1. I tried this doc:

Link to an example

I could create the CryptCodecOpener.class but when I try to connect I get the following Error:

XXXX: JDBC Driver class not found class java.lang.ClassNotFoundException: CryptCodecOpener

Here is the code:

import java.io.File;
import java.io.IOException;
import net.ucanaccess.jdbc.JackcessOpenerInterface;
import com.healthmarketscience.jackcess.crypt.CryptCodecProvider;
import com.healthmarketscience.jackcess.Database;
import com.healthmarketscience.jackcess.DatabaseBuilder;

public class CryptCodecOpener implements JackcessOpenerInterface {
    @Override
    public Database open(File fl,String pwd) throws IOException {
       DatabaseBuilder dbd =new DatabaseBuilder(fl);
       dbd.setCodecProvider(new CryptCodecProvider(pwd));
       dbd.setAutoSync(true);   // Notice that the parameter setting autosync=true is recommended with UCanAccess for performance reasons
       dbd.setReadOnly(false);
       return dbd.open();
    }
}

Where should the class file be?

Jens
  • 45
  • 5

0 Answers0