How to access MS Access database from JDBC?
btw, I dint test it. I just post it for my reference. thanks Angsuman Chakraborty.
How to access MS Access database from JDBC?
private static final String accessDBURLPrefix = "jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ="; private static final String accessDBURLSuffix = ";DriverID=22;READONLY=false}"; // Initialize the JdbcOdbc Bridge Driver static { try { Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); } catch(ClassNotFoundException e) { System.err.println("JdbcOdbc Bridge Driver not found!"); }} /** Creates a Connection to a Access Database */public static Connection getAccessDBConnection(String filename) throws SQLException{ filename = filename.replace('\\', '/').trim(); String databaseURL = accessDBURLPrefix + filename + accessDBURLSuffix; // System.err.println("Datebase URL: " + databaseURL); return DriverManager.getConnection(databaseURL, "", "");}
