How to connect MS Access Database using Java program?

Question

I want to write a program to retrieve data from MS Access database. I wrote program as bellow:

package db;

import java.sql.*;

public class MSaccess_archive {
    public static void main(String[] args) {

        try {

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

            String accessFileName = "E:/L4_project/sample/db/Database";

            String connURL="jdbc:odbc:DRIVER={Microsoft Access Driver (*.mdb, *.accdb)};DBQ="+accessFileName+".accdb;";

            Connection con = DriverManager.getConnection(connURL, "","");

            Statement stmt = con.createStatement();

            stmt.execute("select * from student"); // execute query in table student

            ResultSet rs = stmt.getResultSet(); // get any Result that came from our query

            if (rs != null)
             while ( rs.next() ){

                System.out.println("Name: " + rs.getString("Name") + " ID: "+rs.getString("ID"));
                }

                stmt.close();
                con.close();
            }
            catch (Exception err) {
                System.out.println("ERROR: " + err);
            }
    }

}

But I got Exception as below:

ERROR: java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] Could not find file '(unknown)'.

When I used a .mdb file the above program works correctly but if I use a .accdb file it gives the above exception.

Any ideas why?

Not sure but try changing slashes in: String accessFileName = "E:/L4_project/sample/db/Database"; To double backslash: String accessFileName = "E:\\L4_project\\sample\\db\\Database"; — Jaime Hablutzel
– Jaime Hablutzel, Commented Jul 30, 2011 at 6:34
Note that the JDBC-ODBC Bridge has been removed from Java 8 and is not supported (ref: here and here). UCanAccess is a popular alternative (details here). — Gord Thompson
– Gord Thompson, Commented Mar 20, 2015 at 13:25

rk_P · Accepted Answer · 2012-11-07 04:10:49Z

3

You may revisit steps, Control panel>Administrative Tools>Data Sources>Add>Microsoft Access Drivers(*mdb,*accdb)>ok>ok>ok. It might work.for ODBC connection.

answered Nov 7, 2012 at 4:10

rk_P

2301 gold badge3 silver badges12 bronze badges

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

Comments

Community · Accepted Answer · 2023-11-10 19:48:45Z

3

The JDBC-ODBC Bridge has been removed from Java 8 and is not supported (ref: here and here). UCanAccess is a popular alternative. For details, see

[Manipulating an Access database from Java without ODBC][1]

[1]: Manipulating an Access database from Java without ODBC)).

edited Nov 10, 2023 at 19:48

CommunityBot

11 silver badge

answered Mar 20, 2015 at 13:29

Gord Thompson

125k38 gold badges251 silver badges458 bronze badges

Comments

jtahlborn · Accepted Answer · 2011-08-10 01:18:31Z

1

unless you specifically need to be able to run arbitrary sql queries, you can always give jackcess a try.

answered Aug 10, 2011 at 1:18

jtahlborn

53.8k5 gold badges80 silver badges122 bronze badges

Comments

TimWaters · Accepted Answer · 2013-10-21 15:25:47Z

1

I think you need to specify jdbc:odbc:my_access_odbc_dsn as the URL, where my_access_odbc_dsn is your DSN name as configured in the ODBC. In my case, I was accessing an MS Access 2013 database called "PavoDB", so my URL was:

private static final String url="jdbc:odbc:PavoDB";

answered Oct 21, 2013 at 15:25

TimWaters

273 bronze badges

Comments

duffymo · Accepted Answer · 2011-07-30 03:25:34Z

0

The driver probably hasn't been updated to read that format. .mdb is the original one for Access; .accdb must have been revised and the ODBC driver hasn't kept up.

answered Jul 30, 2011 at 3:25

duffymo

310k46 gold badges376 silver badges571 bronze badges

Collectives™ on Stack Overflow

How to connect MS Access Database using Java program?

5 Answers 5

Comments

Comments

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

Comments

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related