Connecting MS Access Database using JDBC Driver

To connect MS Access database using java we should use JDBC drivers.
We should follow below given steps to connect MS Access database using JDBC.

• Create MS Access database file
• Create a table in the database
• Create a Data Source Name using Microsot Access Driver
• Write a java program to connect MS Access database

Here we are just connecting to MS Access database to test our connection. Apart from that nothing we are doing. We can use MS Access as a database for minor and small scale projects. Adding and retrieving data is so simple with this and several advantages like Easy to Use,Great Storage Capacity, Flexibility, Data Importing and Exporting, Multi User support and Remote Use.