Steps to Connect JSP with Microsoft Access Database


Step 1:

Run                 C:\Windows\System32\odbcad32.exe

OR

                        Navigate to "C:\Windows\SysWOW64"

Find "odbcad32.exe", right click on it and do "Run as Administrator"

Step 2:

Click on System DSN

Step 3:

Add
Microsoft Access Driver (*.mdb, *.accdb)

Step 4:

Write Data Source Name

Example: DriverManager.getConnection("jdbc:odbc:bank","","");
In this DSN is Bank

Step 5:

Database
Select and give Path
Then Click ok

Step 6:

If database not configured then reopen ODBC and configure database path again.


Note: No need of JDBC Driver/ODBC-JDBC Bridge is required.