ODBC Driver install on window vista 64bit

Want to add ODBC driver for Microsoft access on window vista 64bit. Where should I go to install that driver? ODBCadministrator Screenshots
andrishelpAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
grayeConnect With a Mentor Commented:
There is a problem....  the old sytle OleDB  (Jet) drivers for Microsoft Access (and Excel) don't exist for any 64-bit version of Windows.   Recall that ODBC is really just the "front end", and still requires a "back end" driver....  so, having a 64-bit ODBC driver only get's you half way.

Just recently, Microsoft has released a replacement for the OleDB/Jet drivers called "Microsoft Access Database Engine 2010" that does work in the 64-bit world.  However, they are kinda picky to install... for example, the install will fail if you have any 32-bit Office 2010 products installed (to include free PowerPoint 2010 viewer)

http://www.microsoft.com/downloads/en/details.aspx?FamilyID=c06b8369-60dd-4b64-a44b-84b371ede16d&displaylang=en
0
 
burrcmConnect With a Mentor Commented:
Find odbcad32.exe at C:\Windows\SysWOW64, and double click it. You will find the 32bit drivers listed now.

Chris B

0
All Courses

From novice to tech pro — start learning today.