JDBC with ms-access?

Question

How to connect to a Microsoft Access-based database in a Windows using JDBC code?

What syntax is to be written for Type-1 and Type-4 types of the drivers?

Class.forName(" ");

Is the above syntax different for everytype of the driver we use? How can we define and identify the type of the driver we use??

If possible then also specify for the oracle also the driver syntax to be loaded..

You need to use the JDBC-ODBC bridge See: stackoverflow.com/questions/6339055/… for details — Vijay Agrawal
– Vijay Agrawal, Commented Mar 25, 2012 at 20:02
I tried Google, this seemed like a reasonable page, from scanning it: planet-source-code.com/vb/scripts/… — Matt Harrison
– Matt Harrison, Commented Mar 25, 2012 at 20:03
con = DriverManager.getConnection("jdbc:odbc:Driver={Microsoft Access Driver (*.mdb, *.accdb)}; DBQ="+ f.getPath() + "//db//JavaAccess.accd","",""); In the above line for making a connection what does DBQ means and thenafter why f.getPath() + "//db//JavaAccess.accd","",""); is written. Thanks.. — user460920
– user460920, Commented Mar 26, 2012 at 3:47

Michał Niklas · Accepted Answer · 2012-03-27 08:46:15Z

7

You can use JDBC-ODBC bridge by calling:

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver")

Then you can use JDBC database URL in form:

jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=c:\\Nwind.mdb

or if you configure your database in ODBC manager you can use its alias:

jdbc:odbc:northwind

answered Mar 27, 2012 at 8:46

Michał Niklas

54.5k19 gold badges76 silver badges125 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Gord Thompson Over a year ago

Just a note that the JDBC-ODBC Bridge has been removed from the Java 8 JDK and is not supported (ref: here and here). Alternatives include Jackcess and UCanAccess.

SaidbakR Over a year ago

sun.jdbc.odbc.JdbcOdbcDriver does not work any more with Java8

T Hallman · Accepted Answer · 2014-01-20 19:34:23Z

7

I recommend a cross-platform Access JDBC driver called UCanAccess. It works great and there are lots of examples on the site (to help the original poster.)

answered Jan 20, 2014 at 19:34

T Hallman

831 silver badge3 bronze badges

Comments

serg kunz · Accepted Answer · 2013-07-22 09:48:37Z

1

JDBC/ODBC driver is a platform dependent and can be used only in Windows OS. Also, there are some platform independent JDBC drivers, for example: StelsMDB JDBC driver (http://www.csv-jdbc.com/stels_mdb_jdbc.htm)

answered Jul 22, 2013 at 9:48

serg kunz

5311 gold badge4 silver badges9 bronze badges

Comments

user2320365 · Accepted Answer · 2013-12-17 12:14:32Z

-1

To connect Java with MS Access, you need a JDBC driver. I still don't think Microsoft do one do they! http://www.easysoft.com/applications/microsoft-access/jdbc-odbc.html

answered Dec 17, 2013 at 12:14

user2320365

1

Collectives™ on Stack Overflow

JDBC with ms-access?

4 Answers 4

2 Comments

Comments

Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

2 Comments

Comments

Comments

Comments

Linked

Related