Jet Driver – How to find the Microsoft Access Driver (ODBC) in Windows 7 64 bit – SQL Training Online

[sharebox5_no_text] [/sharebox5_no_text]

Where are the Windows 7 Jet Drivers?

The Jet Driver is used for ODBC and allows you to interact with Microsoft Access, Microsoft Excel, and other ODBC sources that don’t have OLEDB drivers.

I went and looked for them today, and they were gone!

You find the ODBC connections in Administrative Tools.

When I opened them up, and clicked ADD, I only saw 4 drivers.

The problem is because, by default, when you are using the 64 bit Windows 7, the ODBC Administrator that opens up is the 64 bit version.

Well, the Jet Driver doesn’t support 64 bit. This means you have to find the 32 bit ODBC Administrator.

I found this article, which showed me the location of my 32 bit ODBC Administrator here:

C:\Windows\SysWOW64\odbcad32.exe

If you open that one up, click on the User DSN tab, and click Add, you will find all of the missing drivers.

So, that’s where they went. Now I see the Jet Driver.

But, you don’t want to go find them every time, do you?

So, I will show you how to create a shortcut in your Administrative Tools.

Open your windows explorer, and navigate to the following location:

C:\ProgramData\Microsoft\Windows\Start Menu\Programs\Administrative Tools

Make a copy of the Data Sources (ODBC)

Rename the copy to Data Sources (ODBC) – 32 Bit

Now go to the properties and change the Target and Start In and replace “system32” with “SysWOW64”. And click OK.

That’s it.

Now you have a shortcut in your Administrative Tools that will pull up the 32 bit version of the ODBC Administrator and you will see the Jet Driver.

Let me know what you think by commenting or sharing on twitter, facebook, google+, etc.