drivers to connect java to MSAccess database

[gransbpa]

Hi,

I'm kind of new in java and want to implement a java developed user interface on a MS Access97 database. What I understood so far is that you have to hardcode the registration of the driver in a class, and then instantiate an instance of that class to connect to the database. My question is: does anyone know which driver(s) I need, where to get them and how to implement them?

Thanks

 

[sedj]

You have two options to connect to an Access db :

Either via a JDBC driver which will act as an interface between straight between your db and your application -
Check out this site :

http://industry.java.sun.com/products/jdbc/drivers/search-results/1,2722,,00.html

This list vendors of JDBC drivers which will connect to MS Accesss. Some are free, some are trial, some you have to pay for.
I would personally go for this option.


Or you could use a JDBC-ODBC brdge (search

http://www.java.sun.com

for one) - in effect a JDBC interface between your application, and an ODBC driver which talks to your db. This option is alot slower because it invokes two drivers - one ODBC and one JDBC.

Whichever option you choose, there will be documentation for installing and implementing with the product.

Ben