Home > Tech Problems > Creating Access ODBC datasource under Windows 7 (64bit)

Creating Access ODBC datasource under Windows 7 (64bit)

I had to create an ODBC datasource for an access database on my Windows 7 machine and for some reason the *.mdb driver doesn’t show up in the control panel ODBC administrator.

After much swearing and google-ing I found the solution.

In C:\windows\sysWOW64 there is an executable called odbcad32.exe. You need to run this exe as administrator to gain access to all the ODBC drivers that come with Microsoft Office, etc.

Thanks Microsoft for another fine product!

Categories: Tech Problems Tags: , , ,
  1. Vaibhav
    September 18th, 2011 at 19:40 | #1

    Thanx a lot…..

  2. ANUPAM
    November 20th, 2011 at 20:07 | #2

    THANK YOU SO MUCH!!!
    IT WORKS!!!

  3. pelino
    January 9th, 2012 at 18:19 | #3

    Thank you. it works perfectly, you really saved me.

  4. HAgz89
    May 9th, 2012 at 13:47 | #4

    THANK YOU!!!!! OMG THANK YOU!!!!

  5. NM
    September 13th, 2012 at 12:39 | #5

    You my saviour too! Thank You!

  6. karthi
    September 29th, 2012 at 05:39 | #6

    ter is no such exe file fr me after tat sysvow64 ter is only folder called oode …wat to do????
    plss help me

  7. Tuck!
    September 29th, 2012 at 07:00 | #7

    That is exactly what I was looking for. Thanks so much!

  8. sathish
    October 9th, 2012 at 11:23 | #8

    thank u for your help

  9. anhphamngoc
    October 9th, 2012 at 15:20 | #9

    thank you for solve my problems!

  10. suman
    October 16th, 2012 at 05:41 | #10

    hai sir..its only working two are three times then automatically destroy all driver information …whats problem what can i do..then hoe can i solve this problem..please tell me..

  11. Alexis
    November 10th, 2012 at 05:32 | #11

    Thanks, was really helpful

  12. Prakash
    November 24th, 2012 at 21:51 | #12

    Hi,

    Thanks a lot. It helped a lot. No where on google we previously got this solution.

    Regards,
    PHN

  13. avadhesh bhatt
    December 14th, 2012 at 06:12 | #13

    thanks a lot…..this worked perfectly !!!!!!!!!!!!!

  14. kuldeep
    December 21st, 2012 at 06:13 | #14

    thank you!!

  15. Bernie
    February 4th, 2013 at 15:42 | #15

    Thanks!!!!!!

  16. shikha
    March 8th, 2013 at 13:34 | #16

    itssssssss really marvelous thx so much its worked…

  17. kris
    March 9th, 2013 at 18:04 | #17

    thank you very much

  18. Bhargav
    March 16th, 2013 at 17:21 | #18

    OMG…..THANKZZZZZ A LOTTTT ….!!!!
    The problm was completely solved ….. Greattt ….!!!

  19. LAKSHIKA
    March 20th, 2013 at 05:42 | #19

    thanks. it works.

  20. venkat vb
    March 27th, 2013 at 14:08 | #20

    Thanks a lot…!!

  21. March 27th, 2013 at 21:39 | #21

    Thank you. It helped me xD

  22. Divyesh
    April 27th, 2013 at 04:51 | #22

    Thank you……!
    IT’s Work Proper……………

  23. chris
    May 15th, 2013 at 02:29 | #23

    Awesome – thanks so much for sharing.

  24. ketan
    September 25th, 2013 at 15:49 | #24

    I can’t select MS ACCESS dbs option in odbc data source admin.from windows7(64 bit)
    as I click on add option.
    plz help me.

  25. anuuu
    May 23rd, 2014 at 02:56 | #25

    thank you!!!!!!!!!!!!

  26. July 11th, 2014 at 21:13 | #26

    Thanks a lot, it was the solution I was looking for!

  27. GAURAV
    July 19th, 2014 at 16:30 | #27

    HOW TO SET THIS PROBLEM PERMANENTLY IN 64 BIT. THIS FIX THE PROBLEM ONLY ONCE.

  1. No trackbacks yet.