Connect to an Access database in Java using NetBeans

Question

How do I connect to an Access database in Java?

I have done like this:

package inspection.management.system;

import java.sql.*;

/**
 *
 * @author Fuhans
 */

public class Database 
{
    public static void DatabaseConnectivity()
    {
        try
        {
            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

            String url = "jdbc:odbc:Driver={Microsoft Access Driver (*.mdb, *.accdb)};DBQ=" + "d:\\program files\\project\\program\\inspection management system\\db1.accdb";

            Connection conn = DriverManager.getConnection(url);

            System.out.println("Connection Successful");
            InfoBox.ShowMessageBox("Connection Successful!", "Success");
        } 

        catch (Exception e) 
        {
            System.err.println("Got an exception!");
            System.err.println(e.getMessage());

            InfoBox.ShowMessageBox("Got an Exception!", "Error");
            InfoBox.ShowMessageBox(e.getMessage(), "Error");
        }
    }
}

if (_textField1.equals("Fuhans") && _passwordField1.equals("Xavega"))
        {
            Sound.PlaySound(1);
            InfoBox.ShowMessageBox("Successfully Login!", "Success");
            Database.DatabaseConnectivity();
        }

When i successfully login, it gave me error on database:

enter image description here

What have i done wrong?

Did you create the data source using the ODBC Administrator app? — OldProgrammer
– OldProgrammer, Commented Nov 15, 2013 at 17:46
not, in the ODBC Administrator app, i don't have Ms access Driver, i just have SQL Driver. But right now for this app, i am using Ms Access. — Kaoru
– Kaoru, Commented Nov 15, 2013 at 17:48
So if there is no Access ODBC driver installed, how do you expect to connect to an Access db then? — OldProgrammer
– OldProgrammer, Commented Nov 15, 2013 at 17:49
in c#, i just connect it through code, no need to set all the things, just create a database and access it through code. But now i am using Java and i don't know how to connect my application in java to the database. Could you please help me sir? — Kaoru
– Kaoru, Commented Nov 15, 2013 at 17:51

Community · Accepted Answer · 2017-05-23 12:27:08Z

2

in the ODBC Administrator app, i don't have Ms access Driver, i just have SQL Driver.

Now that the JDBC-ODBC Bridge has been removed from Java (since Java 8) you should consider using the UCanAccess JDBC driver. It is a pure Java implementation so it works on non-Windows platforms, too.

For more information see

Manipulating an Access database from Java without ODBC

edited May 23, 2017 at 12:27

CommunityBot

11 silver badge

answered Oct 3, 2014 at 20:22

Gord Thompson

125k38 gold badges251 silver badges458 bronze badges

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

Comments

Ysr Shk · Accepted Answer · 2014-04-01 12:58:08Z

1

You should create a DSN(Data Source Name) first.

In control panel, if there is no drivers for accessing even though you have installed then there is a possibility that you may not getting odbcad32.exe file path. Choose your path from this, and then right click Data Sources(ODBC)[where you are creating DSN], and paste one of following path there.

The 32-bit version of the Odbcad32.exe file is located at:

%WinDir%\Windows\SysWoW64
The 64-bit version of the Odbcad32.exe file is located at:

%WinDir%\Windows\System32

and while accessing, do like this:

String url = "jdbc:odbc:dsn_name";
Connection conn = DriverManager.getConnection(url);

answered Apr 1, 2014 at 12:58

Ysr Shk

2245 silver badges16 bronze badges

Comments

Maxime Lorant · Accepted Answer · 2014-06-05 12:12:22Z

0

change the statement:

String url = "jdbc:odbc:Driver={Microsoft Access Driver (*.mdb, *.accdb)};DBQ=" + "d:\\program files\\project\\program\\inspection management system\\db1.accdb";

to:

String url = "jdbc:odbc:Driver={Microsoft Access Driver (*.mdb, *.accdb)};DBQ=" + "C://program files//project//program//inspection management system//db1.accdb";

edited Jun 5, 2014 at 12:12

Maxime Lorant

36.4k19 gold badges91 silver badges97 bronze badges

answered Jun 5, 2014 at 12:08

Mr J

1

Collectives™ on Stack Overflow

Connect to an Access database in Java using NetBeans

3 Answers 3

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related