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?

 

 

 

This Post Has 2 Comments

  1. Hello! I just would like to give a huge thumbs up for the great info you have here on this post. I will be coming back to your blog for more soon.

  2. Very great post. I just stumbled upon your weblog and wished to mention that I’ve really enjoyed surfing around your blog posts. After all I will be subscribing in your feed and I’m hoping you write again soon!

Leave a Reply