Granny's Programming Pearls
"inside of every large program is a small program struggling to get out"
JavaRanch.com/granny.jsp
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 Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "MS access" Watch "MS access" New topic
Author

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
Sheriff

Joined: Oct 27, 2005
Posts: 19655
    
  18

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.


SCJP 1.4 - SCJP 6 - SCWCD 5 - OCEEJBD 6
How To Ask Questions How To Answer Questions
 
 
subject: MS access
 
Similar Threads
Jakarta POI
ConnectionPoolilng from MS Access
JDBC & SQL Error List Help
Data Base Tip
database in netbeans