Home
Accessing MS Access 2007 on NetBeans 6.5 using JDBC, Part 1: Introduction

Accessing MS Access 2007 on NetBeans 6.5 using JDBC, Part 1: Introduction

August 24, 2009 Java 3 Comments
This entry is part 1 of 4 in the series Accessing MS Access 2007 on NetBeans 6.5 using JDBC

Accessing MS Access 2007 on NetBeans 6.5 using JDBC

Accessing Access 2007 on NetBeans 6.5 using JDBC

Here comes again, a tutorial about accessing database on NetBeans. In 2007, I wrote two tutorials which are accessing SQL Server on NetBeans using JDBC and accessing MySQL on NetBeans using JDBC. Both tutorials are useful to many people so I decide to write a new one, Accessing MS Microsoft Access 2007 on NetBeans. This series shows how to use NetBeans 6.5 to connect to a Microsoft Access 2007’s database using JDBC. After the connection is established, you see how to perform basic SQL operations such as SELECT, INSERT, UPDATE and DELETE on a table and get result (if any) to display on console window.

I divide this series into 4 parts:

  1. Accessing MS Access 2007 on NetBeans 6.5 using JDBC, Part 1: Introduction
    The post that you are reading.
  2. Accessing MS Access 2007 on NetBeans 6.5 using JDBC, Part 2: Prepare Northwind Database
    This post shows you how to prepare Northwind database of Microsoft Access 2007.
  3. Accessing MS Access 2007 on NetBeans 6.5 using JDBC, Part 3: Create a Connection
    This post shows how to establish a connection to the Northwind database on NetBeans 6.5.
  4. Accessing MS Access 2007 on NetBeans 6.5 using JDBC, Part 4: Perform SQL Operations
    This post shows how to perform basic SQL operations such as SELECT, INSERT, UPDATE and DELETE on Customer table on Northwind database.

Requirements

Here are the software requirements which I use on this series.

  • NetBeans 6.5.1
  • Northwind sample database for Microsoft Access 2007
Series NavigationAccessing MS Access 2007 on NetBeans 6.5 using JDBC, Part 2: Prepare Sample Database >>

Related Posts

3 Comments

  1. Sahil Jain February 29, 2012

    how to connect ms access 2007 database in case the database is password protected ??

  2. hanan mohammed March 10, 2012

    how to bind data to a database by just clicking a button in java.

  3. souma March 26, 2012

    is there any tutorial how todisplay the data of the data base in a JTable and thanks

Leave a Reply