how to connect to my MS Access DB through JDBC but not ODBC

[adachi]

Hi,
I am developing a software that want to connect to a ***.mdb when I distributed it. So, I can't set anything in the client's computer such as ODBC. Thus, I want to use JDBC connect to the Database directly.
Can I?
Thanks for you attention

[David O'Meara]

Does this thread cover what you are looking for?
Dave
[This message has been edited by David O'Meara (edited November 25, 2001).]

[David O'Meara]

"adachi",
The Java Ranch has thousands of visitors every week, many with surprisingly similar names. To avoid confusion we have a naming convention, described at http://www.javaranch.com/name.jsp .
We require names to have at least two words, separated by a space, and strongly recommend that you use your full real name. Please log in again with a new name which meets the requirements.
Thanks.
Dave

[Jamie Robertson]

I think you are looking for a DSN-less connection to access:

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
sconn = DriverManager.getConnection("jdbc:odbc:Driver={MicroSoft Access Driver (*.mdb)};DBQ=C:\\Temp\\data\\emp.mdb","Admin","");

this will connect to the emp database located at C:\Temp\data
Jamie
note, this still uses the jdbcdbc bridge so you can only connect to a local database (I haven't tested it).

[This message has been edited by Jamie Robertson (edited November 26, 2001).]
[This message has been edited by Jamie Robertson (edited November 26, 2001).]