Para quem quer efetuar a conexão com o Access, segue um exemplo:
public class ConectaBanco {
private String database = "jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=";
private String base = "C:\\Documents and Settings\\EDUARDO\\Meus documentos\\curso.mdb";
private Connection conn = null;
private Statement stmt;
public ConectaBanco(){}
public void conectaBanco(){
try{
database += base;
conn = DriverManager.getConnection(database);
stmt = conn.createStatement();
stmt.executeQuery("insert into aluno(Aluno,Telefone,Email) values('Marcio','88727245','[email removido]')");
}
catch(Exception e){
e.getMessage();
}
}
}
