How to Create ODBC Connection to a Microsoft Access Database?

How to Create ODBC Connection to a Microsoft Access Database?

For the Java back end generally includes a Web server that hosts an application (built with code like PHPPythonRuby on Rails, C/C#/C++, .NET, or Java), which communicates with a database using something like MySQL or Microsoft Access to serve up the information that the front-end presents.

Following are the steps for creating an ODBC connection to a Microsoft Access database:-

Step 1:

Click on start menu -> Select Control panel -> Select Administrative Tools 

                                          Or

Type in the search bar Administrative Tools 

How to Create ODBC Connection to a Microsoft Access Database?

Step 2:

Double click the Data Sources (ODBC) icon -> Select System DNS -> Select ADD

How to Create ODBC Connection to a Microsoft Access Database?

Step 3:

Select Microsoft Access Driver (*.mdb, *.accdb) from the driver’s list and click on the Finish button.

How to Create ODBC Connection to a Microsoft Access Database?

Step 4:

Give Data Source Name -> Click on Select button

How to Create ODBC Connection to a Microsoft Access Database?

Step 5:

Now select the database file and click on OK.

How to Create ODBC Connection to a Microsoft Access Database?

Step 6:

Click on OK to exit the ODBC Data Source Administrator window.

How to Create ODBC Connection to a Microsoft Access Database?

 

 

 

Leave a Reply