MS Access

[timothy ma and constance lee]

All

Can Java connect to MS ACCESS as database using jdbc or odbc? please help

 

[David Segall]

All

Can Java connect to MS ACCESS as database using jdbc or odbc? please help

Sun list 23 JDBC drivers for MS Access
<http://developers.sun.com/product/jdbc/drivers>. The Java SDK comes
with the JDBC-ODBC bridge driver
<http://java.sun.com/j2se/1.3/docs/guide/jdbc/getstart/bridge.doc.html>
which allows you to connect to MS Access using Microsoft's ODBC
driver. Sun don't recommend its use for production work but then few
people would recommend an Access data base for production work.

 

[Roedy Green]

Can Java connect to MS ACCESS as database using jdbc or odbc? please help

see http://mindprod.com/jgloss/jdbc.html#CONNECTING the odbc bridge.

 

[Roedy Green]

Can Java connect to MS ACCESS as database using jdbc or odbc? please help

There are quite a few JDBC drivers for Access. See
http://developers.sun.com/product/jdbc/drivers

You can also use the el-cheapo ODBC bridge approach.

see http://mindprod.com/jgloss/jdbc.html#CONNECTING