64 bit ODBC driver for Microsoft Access

Hello,
I am trying to connect to one of my Access databases (.mdb file on my local) from ODBC connection. The problem is, I am using 64-bit Xp Pro and it does not see any Access driver on 64-bit architecture.
Does anybody have 64-bit compatible ODBC driver for Microsoft Access Any other help also will be appreciated....



Answer this question

64 bit ODBC driver for Microsoft Access

  • Indigo Cowboy

    I saw this while trying to resolve a similar problem. Let us know if this helped, or if you have resolved this somehow..

    http://archives.postgresql.org/pgsql-odbc/2005-09/msg00125.php

    Thanks..


  • sai111

    There is not one available. You need to compile your application for the x86 processor to force it to use the 32 bit driver.

  • Jboul

    Ken is correct - I ran into the same problem. And, compiling against x86 fixed the problem. This is the *only* way to run Jet 4.0 on x64.

  • Czar Eclarinal

    Run it through SQL Server Express (which is 32-bit)

    http://gorm-braarvig.blogspot.com/2005/11/access-database-from-sql-200564.html

    Not straight-forward but a lasting solution, hope this helps, Gorm



  • Sam Vella

    Hi

    To continue the theme. Heeeelpppp.

    Am i right in thinking that there is absolutelly no way to read and write data into an Access Database from VS2005 on a 64 bit machine, with my app running in 64 bit mode

    I cannot compile to x86

    I cannot use SQLXpress

    Any ideas at all would be greatly appreciated

    Glen


  • SOAC

    Can any of you tell an "average Joe" how to compile the application against the x86 processor I'm not a developer just a sys admin trying to connect to an Access db - thanks!

    Paul


  • 64 bit ODBC driver for Microsoft Access