First, use the jdbc access driver: Download The JDBC driver for ACCESS in industry. java. sun. comproductsjdbcdrivers. Second: access using the JDBC-ODBC Bridge: Class. forName (sun. jdbc. odbc. JdbcOdbcDriver); connDriverManager. getConnection (jdbc: odbc: dbacc
First, use the jdbc access driver: Download the access jdbc driver at http://industry.java.sun.com/products/jdbc/drivers. Second: access using the JDBC-ODBC Bridge: Class. forName (sun. jdbc. odbc. JdbcOdbcDriver); conn = DriverManager. getConnection (jdbc: odbc: dbacc
First, use the jdbc access driver:
Download the access JDBC driver at http://industry.java.sun.com/products/jdbc/drivers.
Second: access using a JDBC-ODBC Bridge:
Class. forName ("sun. jdbc. odbc. JdbcOdbcDriver ");
Conn = DriverManager. getConnection ("jdbc: odbc: dbaccess ");
Third: direct ACCESS to the ACCESS database, without the use of JDBC-ODBC Bridge:
Class. forName ("sun. jdbc. odbc. JdbcOdbcDriver ");
String url = "jdbc: odbc: driver = {Microsoft Access Driver (*. mdb)}; DBQ = access \ dbaccess. mdb ";
String uname = "";
String password = "";
Connection conn = DriverManager. getConnection (url, uname, password );
Note:
The access 2007 database driver file is dedicated to accessdatabaseengine.exe.
Access 2010 download here: http://download.microsoft.com/download/2/4/3/24375141-E08D-4803-AB0E-10F2E3A07AAA/AccessDatabaseEngine.exe
Access2007 or 2010 connection string:
String strurl = "jdbc: odbc: DRIVER = {Microsoft Access Driver (*. mdb ,*. accdb)}; DBQ = F:/Program Files/apache-tomcat-7.0.8/webapps/ROOT/mywebstore. accdb ";