SQL Training Online

  • Training Courses
  • Beginner Book
  • Blog

October 23, 2012 by Joey Blue Leave a Comment

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

Video: Jet Driver – How to find the Microsoft Access Driver (ODBC) in Windows 7 64 bit – SQL Training Online
In this video, I show you how to find the Jet Driver (ODBC) that is missing in Windows 7.

[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.

ODBC Jet Drivers for Windows 7

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.

Filed Under: SQL Training Tagged With: Microsoft Access, ODBC

Recent Posts

  • SQL Database Normalization – 1NF, 2NF, 3NF, and 4NF
  • SQL Joins Tutorial for Beginners – Inner Join, Left Join, Right Join, Full Outer Join – SQL Training Online
  • Zillow House Price Analysis from CSV Archive – #PowerBI 002
  • Learn Basic SQL – 1 Hour Training Course – SQL Training Online
  • Create Table Statement in SQL Server and Inserting Baseball Homerun Leader Dataset – SQL Training Online

Popular Posts

  • SQL Functions
  • SQL Jobs in Oracle and Microsoft SQL Server
  • Troubleshooting a SQL Join
Copyright © 2025 · SQLTrainingOnline.com · Consulting at EmbarkBlue.com