import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;



import sun.jdbc.odbc.*;
public class JavaToAccessDB
{
	private static Statement stmt;
	private static Connection conn;
	private static ResultSet rs;
	
	private static void connect()
	{
		try
    	{
            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
            /*
             * AccessDSN is configured in Administrative Tools -> Data Sources (ODBC)
             */
            conn = DriverManager.getConnection("jdbc:odbc:AccessDSN"); 
    	}
        catch (Exception e) 
        {
        	System.out.println("Error: " + e);
        }
	}

	public static void main(String[] args)
	{
		connect();	
	    try {
	        stmt = conn.createStatement();
	        rs = stmt.executeQuery("SELECT COUNT(*) FROM B2BIncidentTable");
	        while (rs.next()) {
				System.out.println("Count = " + rs.getString(1));
			}
		 	rs.close();
		 	stmt.close();
		}
        catch (Exception e) 
        {
	         System.out.println("Error: " + e);
	    }
	}
}