从google.com搜到的，ms access的连接方式（不设ODBC DSN）

[rootwuyu]

import java.sql.*;

public class test{
public static void main(String[] args){
//Authors
try{
String dbname="/TEMP/BIBLIO.MDB";
String dbinfo = "jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ="+dbname;
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection conn = DriverManager.getConnection(dbinfo);
Statement stmt = conn.createStatement();
ResultSet RS = stmt.executeQuery("SELECT * FROM Authors");
while(RS.next()){
System.out.println(RS.getString(2));
}
RS.close();
RS=null;
stmt.close();
stmt=null;
conn.close();
conn=null;
}
catch(java.lang.Exception e){
System.err.println(e);
}
}
}