Java connection to MS Access Database

Question

Just wondering if anyone cane help me, I'm trying to connect to an MS Access Database. I have done it on other projects and used exactly the same code. Can anyone see if I have done anything wrong?

try {
        System.out.println("Attempting Database Connection");
        Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
        String sourceURL = "jdbc:odbc:Driver={Microsoft Access Driver(*.mdb)};DBQ=MotivationDatabase.mdb;";
        connection = DriverManager.getConnection(sourceURL, "", "");
        stmt = connection.createStatement();
        System.out.println("Connection made");
    } catch (Exception e) {
        System.out.println("Database connection attempt failed");
        System.out.println(e);
    }

I keep getting the error:

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

But my database is in the same folder as my project like I've done before s I'm not sure why i am getting this error. Help?

You need to specify the full path to the .mdb file in the JDBC URL. — user330315
– user330315, Commented Mar 9, 2014 at 15:01
@Sandeep: of course he/she is. It's the JDBC/ODBC bridge that is being used, but it's still JDBC — user330315
– user330315, Commented Mar 9, 2014 at 15:48

Sandeep Chatterjee · Accepted Answer · 2015-06-09 08:01:17Z

2

Control Panel -> Administrative Tools -> ODBC Data Sources -> Add -> Microsoft Access Driver(*mdb,*accdb)
Specify the correct path to MotivationDatabase.mdb corresponding to Data Source name and save the settings.

Refer here.

enter image description here

Code:

public class Main {

    @SuppressWarnings("unused")
    public static void main(String[] args) {

        try {
            System.out.println("Attempting Database Connection");
            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
            String sourceURL = "jdbc:odbc:Driver={Microsoft Access Driver (*.mdb, *.accdb)};DBQ="
            + "D:\\MotivationDatabase.mdb";
            Connection connection = DriverManager.getConnection(sourceURL);
            System.out.println("Connection made");
        } catch (Exception e) {
            e.printStackTrace();
        }

    }

}

Output:

enter image description here

P.S: Please learn to work with JDBC as JDBC-ODBC Bridge will be removed in JDK8.See here.

EDIT:

You can also use JDBC along with UCanAccess API to connect to an MSAccess database. You would need the following jars in your project build path.

commons-lang-2.6.jar
commons-logging-1.1.1.jar
hsqldb.jar
jackcess-2.1.0.jar
ucanaccess-2.0.9.5.jar

Code:

connection = DriverManager
.getConnection("jdbc:ucanaccess:////REMOTE-IP-ADDRESS/shared-folder/TestDB.mdb");
System.out.println("CONNECTION ESTABLISHED....");

Works fine with JDK8. You can download the entire source code from here.

edited Jun 9, 2015 at 8:01

answered Mar 9, 2014 at 14:08

Sandeep Chatterjee

3,2489 gold badges34 silver badges52 bronze badges

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

1 Comment

user3365117 Over a year ago

I've already done this and still the same error, I'm at a loss to where I've gone wrong if I'm honest.

AndreaTaroni86 · Accepted Answer · 2014-03-09 15:09:29Z

0

Sun JDBC ODBC will notte work with MS access when java 8 will ne release: I suggest you to use apache poi project. It s simple and works great.

Yeah it's correct the right project is jakcess:

import com.healthmarketscience.jackcess.DatabaseBuilder;
import com.healthmarketscience.jackcess.Row;
import com.healthmarketscience.jackcess.Table;
try{Table table = DatabaseBuilder.open(new File("filename")).getTable("tablename");
    righe.add(0);
    for(Row row : table) {
        String articolo=row.get("ColName").toString();

edited Mar 9, 2014 at 15:09

answered Mar 9, 2014 at 14:58

AndreaTaroni86

55913 silver badges30 bronze badges

Comments

Mohammad Hossein Nik-khah · Accepted Answer · 2019-01-15 11:29:25Z

0

Try this class forename and connection URL.Add the below jar files to your projects:

commons-lang.jar,commons-logging.jar,hsqldb.jar,jackcess.jar,ucanaccess.jar

Class.forName("net.ucanaccess.jdbc.UcanaccessDriver");
//change the path with your own accdb file
String URL = "jdbc:ucanaccess://D:\\projects\\test.accdb";
Connection con = DriverManager.getConnection(URL);

answered Jan 15, 2019 at 11:29

Mohammad Hossein Nik-khah

12 bronze badges

Collectives™ on Stack Overflow

Java connection to MS Access Database

3 Answers 3

Code:

Output:

EDIT:

Code:

1 Comment

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Code:

Output:

EDIT:

Code:

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related