How To Connect Ms Access Database in Java - Microsoft Access Tutorial ✅ - April 2025

How To Connect Ms Access Database in Java

We know that Access templates can be used with other application, but have you ever wonder on How To Connect Ms Access Database in Java? Well, like C# there are several ways in doing so, but it is much simple and easier. You will need additional tools to prepare and some steps to do it.

The most popular is by using JDBC driver. You can download and install them first. There are lots of developers who provide the driver, free or paid ones. Even Microsoft and Oracle (the organization who develop Java) provide the drivers too. In some cases, Microsoft even include the drivers along with Windows OS.

After you install the JDBC driver, you will need an access database. If you have them both, now follow this instruction:

1. Go to Control Panel. In search box, type: Administrative Tools. Open it. In the Administrative Tools panel, open ODBC Data Sources.

2. In the dialog box, click Add. A new pop-up will appear. Select Microsoft Access Driver (*.mdb. *.accdb) and hit Finish.

3. A new pop up for setup will appear.

Tutorial How To Connect Ms Access Database in Java

Rename the new Data Source. Next, click Select. A new pop up will appear again. Navigate to your access database then hit OK.

4. In the Access Setup dialog box, hit Create before you hit Finish.

5. Now, after you done the essential things for setting up JDBC and ODBC, it is time to open your Java application. Import the java.sql in your Java Program.

Then, input the java code for connecting the access database with the Java Program. The most common code is like the below code. Make sure to change the highlighted code with your own value.

import java.sql.*;
public class Test1 {
public static void main(String args[]) {
Connection con;
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con = DriverManager.getConnection("jdbc:odbc:Temp");
Statement stmt = con.createStatement();
stmt.executeUpdate("CREATE TABLE BOOKS " +
"(BOOKTITLE VARCHAR(32), BOOKID INTEGER, MEMBERID INTEGER,
"MEMBERNAME VARCHAR(32), DATEBORROW DATE)"); }
// Catch any exceptions that are thrown.
catch(ClassNotFoundException e) {
System.out.println(e.toString()); }
catch(SQLException e) {
System.out.println(e.toString()); }
}
}

Please note that there are still lots of code that you can find. You may need to adjust those codes with your own databases value. Good luck in connecting your database to Java.

Frequently Asked Questions

Which Microsoft Access software version work with this database?

This database template will work optimally on MS access software version 2016 and the latest 2019 version. You can use the older version but it may caused bug or error.

How to Download This Access Database Template?

Simply go to our homepage and browse the template you want to use, you can also use search form function to get templates in specific keyword. You can Register Here and become our paid member if you want to get all templates without download limitation in unlocked version.

Is It Safe To Download This Database from This Website?

We've been serving our users since 2011, you can verify here. We are always committed to build a secure and user-friendly database for our users, and thats why we still exist in this business until today. You can also verify our website security using McAfee, and you can directly scan the downloaded database using VirusTotal or any other Antivirus software you have in your computer. All access databases and templates on this website are 100% free from virus, malmware or any other harmful objects.

Can I Modify The Database Template?

Yes, you can modify all of our templates to fit your needs as long its for personal, education or non-profit use only. If you want to modify and use it for commercial or business purposes, you have to buy extended licence separately. Read more: Terms of Use.

How to Download Microsoft Access 2016 or 2019 Software?

You can purchase Microsoft Office Access here:

Can I Request for Access Database Modification Service to Fit My Needs?

Yes, we are open for any kind of modification service on microsoft access templates and databases. You can send your access modification request here.

How Can I Contact Microsoft Access Programmer?

You can contact our programmer using the contact page on this website, or if you need faster response you can send us WhatsApp Message to +1-(786)-886-3099 (working hours only) and Priority support only available for paid members. If you don't get answer by phone due to heavy work-load on all of our staffs, we suggest you to send a whatsapp message or email admin@access-templates.com