How to Install Microsoft Access ODBC Driver

In this tutorial, we will guide you how to install the MS Access odbc driver. We will teach you how to do so in two different ways.

Learn how to install the data source (odbc) driver in Microsoft Access. Furthermore, learn how to install the driver through the run command.

Step 1 -- Open Control Panel

First of all, open up the Start menu and click on the Control Panel.

Step 2 -- Open Administrative Tools

In the control panel window, open up the Administrative Tools.

Step 3 -- Open odbc file

With that done, the Administrative Tools window will open up. Over there, we will need to open up the Data Sources (ODBC) file.

Step 4 -- Click on the add button

Here in the ODBC Data Sources Administrator window, click on the Add button to add odbc driver for access.

Step 5 -- Select MS Access Driver

Once the new window opens up, scroll down and select the Microsoft Access Driver option and click on the Finish button once done.

Step 6 -- Set data source name

This will open up the ODBC Microsoft Access Setup. Over there, in the Data source name field, type MS Access and click on the Ok button.

Step 7 -- ODBC driver installed

Now you will be brought back to the ODBC Data Sources Administrator window. Over there, you will see at the bottom that you have successfully installed the Ms Access odbc driver.

Step 8 -- Install odbc via run

Alternatively, you can also open the ODBC Data Sources Administrator window from run command. In order to do so, simply type in odbcad32 and hit the enter key in order to install odbc driver for access.

And that's it.

[howtechoffice]

❗ Subscribe To Our Main YouTube Channel

[JefferyHallett]

Mislabeled. This does not show how to install the ODBC driver.

[sivaram]

This is configuring a data source.... NOT installing a driver.

[frankschwertfeger]

Very helpful movie. Astonishing: it works!!!
But:The tutor talks like he is on the run. Maybe to Sweden ...
Starting and stopping the movie now and then helps getting the message.
You made a gloomy autumn day brighter!

[EdHansberry]

This doesn't tell you how to install anything, only how to configure a driver. Very misleading, especially for those that don't have the ACCDB driver installed and are trying to figure out how to install it.

[philipjames]

I had the driver installed, and this helped so fucking much, i was sitting there so fucked up about what SQL server to use, this helped so much!

[saviolagarf]

Hi, if i can't see any of those options, only the SQL Native Client Drivers, how can i install or see the other options?

[manwellcrackelbum]

Yeah, this does not tell you how to install a it tell you how to configure a connection. The actual driver must already be installed. Title fail.

[kumbakonamponnu]

Actually I want some clarification.. if micro soft access run in one system and that was not run in another system. I want to know how to run the new micro soft access in another system..

[egormescheryakov]

This is not ODBC Driver setup video - but just DSN Setup!

[NeiltheNotSoBrave]

Constructive suggestion: a more appropriate video title would be along the lines of "How to Configure ODBC to use your MS Access driver".  What is even more disappointing is despite repeated feedback, some as much as 12 months ago, you have failed to rectify the problem. 

[isobelgraham]

Yep - I don't get it. When I click Add, I can't select the Microsoft Access Driver option. It isn't there. How can I install that?

[mohitjoshi]

where can i download theswe drivers . i dont have any

[patgrimm]

This does not show how to install the driver but merely how to configure a DSN.

[Uniquesoftdev]

This is not installation of driver only setup

[edwardspencer]

This is how to USE the driver NOT how to install it.

[taotao]

bad Video. This is not about installing an ODBC driver!