This week's book giveaway is in the Servlets forum.
We're giving away four copies of Murach's Java Servlets and JSP and have Joel Murach on-line!
See this thread for details.
The moose likes JDBC and the fly likes MS access Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "MS access" Watch "MS access" New topic

MS access

lokesh rajarathnam
Ranch Hand

Joined: May 17, 2007
Posts: 35
Hello all

I want to know how to get connect with MS Access(jdbc odbc bridge)

please any one give me in simple compilable program in java
Rob Spoor

Joined: Oct 27, 2005
Posts: 19651

First you'll need to load the driver. It's already shipped with the JVM, and it's "sun.jdbc.odbc.JdbcOdbcDriver".

Next you need the connection string: "jdbcdbcRIVER={Microsoft Access Driver (*.mdb)};DBQ=" followed by the Access file.

How To Ask Questions How To Answer Questions
It is sorta covered in the JavaRanch Style Guide.
subject: MS access
Similar Threads
Jakarta POI
ConnectionPoolilng from MS Access
JDBC & SQL Error List Help
Data Base Tip
database in netbeans