package javaapplication1;


import java.io.File;
import java.io.IOException;
import net.ucanaccess.jdbc.JackcessOpenerInterface;
import com.healthmarketscience.jackcess.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.setAutoSync(false);
   dbd.setCodecProvider(new CryptCodecProvider(pwd));
   dbd.setReadOnly(false);
   return dbd.open();
}

}

package javaapplication1;
import java.sql.*;
public class JavaApplication1 {
static Connection con;
static Statement st;
static PreparedStatement pst;
static ResultSet rs;

public static void main(String[] args)
{
    // TODO code application logic here

    try
    {
        //Class.forName("net.ucanaccess.jdbc.UcanaccessDriver");
     String env=System.getenv("ProgramFiles");
     //Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
    String dbURL = "jdbc:ucanaccess://C:\test.accdb;jackcessOpener=CryptCodecOpener";
     //String dbURL = "jdbc:ucanaccess://"+env+"\RSSBV0\db\rssboffdb.accdb";
     //String username="";
     String username=System.getProperty("user.name");
     String password="r$$b231";
     con = DriverManager.getConnection(dbURL,username,password);
     String query = "select username from userstb";
     pst = con.prepareStatement(query);
     rs = null;

     try
     {
        rs = pst.executeQuery();

        while(rs.next())
        {
            System.out.println(rs.getString("username"));
        }
     }
     catch (Exception e)
     {
       pst.close();
       con.close();
     }
    }
    catch(Exception e)
    {
        System.out.println(e);
    }


}

}