jdbc to access complete database

Question

i want what should be given in DriverManager.getConnection() when i want to access all tables from ms-access

Answer 1

Have a look at DriverManager.getConnection(String url, Properties info). What problem doesn't this solve?

Answer 2

I think you want to connect to an MS Access DB without creating a DSN.

In any case this works fine with acess everytime.

DriverManager.getConnection("jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=C:/data/data.MDB","","");

Change the DBQ argument to your MDB file.