Java and Access

shlen

Looking to connect a java application with access 2007 anyone know which drivers to use and code??? Im trying to change the colour of the background in netbeans i tried right clicking and going into the properties but it doesnt do anyhting it just stays the same colour!

FSL

When you say connect a Java application to Access 2007 do you mean you wish to modify an Access 2007 project or just manipulate the database?

shlen

just mainipulate the database, read only functionality is all im looking to do!

FSL

The ODBC driver for an Access 2007 database is ACEODBC.dll. It should conform to ODBC standards. I've never used it as I've only ever used Access for reports. I always use an SQL server for data.

stephenlane80

you can do it in native java with the sun jdbc driver, this example is for 2003, you wil have to check the documentation to see what parameters 2007 needs:

import java.sql.*;
class Test


    {
    public static void main(String[] args)


        {


            try {
            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
            // set this to a MS Access DB you have on your machine
            String filename = "d:/java/mdbTEST.mdb";
            String database = "jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=";
            database+= filename.trim() + ";DriverID=22;READONLY=true}"; // add on to the end 
            // now we can get the connection from the DriverManager
            Connection con = DriverManager.getConnection( database ,"",""); 
        }



            catch (Exception e) {
            System.out.println("Error: " + e);
        }

    }

}