Paul Clapham wrote:
Oh, is that all? Then I think your question was fully covered in this Ranch post from last year: https://coderanch.com/t/546920/JDBC/databases/JDBC-MS-Access-without-ODBC.
Thank you, Paul, for your reply. I think I found a way to do it through a type4 driver called
HXTT Access Pure Java JDBC Driver. It can be downloaded from
here
I downloaded version 4.0 which is compatible with 1.6 JDK and this is how it is setup.
1- Download the file, unzip it then go to the lib directory and copy the jar file to your project workspace.
2- In Eclipse open your project, then go to run menu- run configurations then in the classpath tab you can add the jar file using the (add external jars) button.
3- You need to change the url
string of your database file. For example if you're using Access2007 then you change it to:
String url= "jdbc:access:/./nameOfYourDatabase.accdb";
For further information please visit the HXTT documentation whcih can be found in the file you downloaded from the link above.
Thanks.