Microsoft Access ODBC Driver for Vista 64 bit

Discussion in 'Windows Vista General Discussion' started by Richard, Feb 15, 2007.

  1. Richard

    Richard Guest

    Hi,

    Does anyone know where/how I get an ODBC driver for Microsoft Access ODBC
    Driver on Windows Vista 64 bit?

    At the moment, when I open the ODBC Data Source Administrator and click on
    the "Drivers" tab, only "SQL Server" is listed.

    If anyone has got any ideas, I'd really appreciate them.

    Thanks in advance,

    Richard
     
    Richard, Feb 15, 2007
    #1
    1. Advertisements

  2. Richard

    soupbowl Guest

    Did you find a resolution to this problem? I am experiencing the same.

    Vista x64 with Office 200
     
    soupbowl, Feb 25, 2007
    #2
    1. Advertisements

  3. Richard

    Richard Guest

    Hi Soupbowl,

    I found a workaround, which was to use a different ODBC tool.

    The ODBC tool I was trying and having the problem was
    C:\Windows\System32\odbcad32.exe

    The other one, C:\Windows\SysWOW64\odbcad32.exe, has loads of database
    drivers in it, so when I use this one, I was able to set up an ODBC
    connection to my access database!

    I think that one of these exe's is the 32 bit version and the other is the
    64 bit version.

    Please let me know how you get on.

    Richard.
     
    Richard, Feb 25, 2007
    #3
  4. Richard

    JODEAN Guest

    Does anyone know what the solution is to this problem?
     
    JODEAN, Feb 27, 2007
    #4
  5. Richard

    Semitechie Guest

    I had this problem and looked through all the forums without success
    but finally found a solution. I have an Access database with linke
    tables that connects to an SQL server elsewhere. It worked on Window
    2000, XP, and my 32 bit Vista laptop, but not on the 64bit Vist
    desktop. I tried setting up a System DSN through ODBC drivers in th
    Control Panel. The test worked there, but when I opened the Access fil
    it said it couldn't find the ODBC driver and therefore I couldn't ope
    the linked tables.
    The solution (found by carefully following instructions in the onl
    Access manual I could find that even had ODBC in the index) was to se
    up the driver from within Access 2007, using Get External Data/More/ODB
    database/linked tables. That opened up the same window you get from th
    Control Panel. It would not let me set a Machine connection, but di
    permit a User (file level) connection. I just had to click on the SQ
    server driver and the usual set of questions appeared. When I finished
    the connection worked. Once the connection was established, it als
    shows up as a User DSN in the ODBC drivers via Control Panel.
    I think the problem is that 64 bit Vista has another level o
    security, so that it only lets you make a connection that is specific t
    the file, and by doing it from inside Access, that lets the OS know tha
    you're dealing with a 32 bit application.
    There is a bunch of stuff in other forums about how there are tw
    different Access drivers in different directories in Windows. I foun
    both of those on my computer, but didn't have a clue what to do with th
    information. If you are making any kind of a connection for an Acces
    database, the solution seems to be not to go searching for apparentl
    missing drivers but to just establish the connection from inside Acces
    2007, where you get the old familiar list of all sorts of drivers. M
    control panel User DSN window also shows a phantom Access 2007 drive
    that it says doesn't exist, but all the drivers are there if you star
    from inside your Access database
     
    Semitechie, Feb 9, 2009
    #5
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.