Microsoft Access ODBC Driver 64-bit Solved/Closed

Question

Hello everyone,

I have a PC running Windows 7 Professional 64-bit, and I programmed a JAVA application that needs to access a Microsoft Access database.
My problem is that when I try to add my database using the Windows ODBC Data Source Administrator tool, I encounter an error message. It’s rather "normal" since the only ODBC drivers installed on my machine are for SQL Server.
Therefore, I have been looking for a 64-bit Access ODBC driver for quite some time but I can't find one.
Where can I find it? Does it simply not exist? If that's the case, how can I proceed?

Thank you in advance for your responses.

PS: I wasn't sure which category to post this message in.

Configuration: Windows 7 Firefox 3.5.5

Mick Sgrill · Accepted Answer

Apparently, you need to use the ODBC Data Source Administrator utility for 32-bit; to run it: c:\windows\syswow64\odbcad32.exe

Mick Sgrill · Answer

Hello,  Sorry, I don't have the answer; I have the same problem too...

Mick Sgrill · Answer

I don't understand why a solution isn't found right away. It's definitely something quite essential.

Mick Sgrill · Answer

'Hello,  It's always the same thing, you find exactly what you're not looking for; this is somewhat true for the web in general.

Mick Sgrill · Answer

Sure, that works, it's made for it! 8-)

laguille64 · Answer

Hello everyone,
I have the same setup as you. Windows 7, IIS, and an ASP site with an Access database. I found the ODBC management under system32 where I can see the drivers, but... I'm still at the same point. Did you add any driver or perform any special action?
The error I get when I run IIS is the same as yours. The string

set Conn = Server.Createobject("ADODB.Connection")
ConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="& Server.Mappath("db.mdb")

gives me an error (provider absent...)

Thank you in advance for your responses.

electra85 · Answer

Hi, sorry for this message, I know it's not the right place to ask the question, but if you're still online, you can reply if you know the answer. I've created a database that generates invoices in Access 2007, and I want the invoice number to be in the format year+month+sequence (resetting at the beginning of each month).
Please, if you can help me, it's urgent ^^

Theviolinmaster · Answer

To compile in 32 bits: Project properties -> "Compiler" tab -> click on the "Advanced compilation options" button -> Change "Target platform" to "x86" -> Re-compile  It should normally work (VS 2008)

fff · Answer

Thank you so much, wam, for the simple solution, but it had to be found. AWESOME :)

krysmas17 · Answer

Hi,

Microsoft offers a beta solution for the 64-bit Access ODBC driver:

http://www.microsoft.com/downloads/details.aspx?FamilyID=C06B8369-60DD-4B64-A44B-84B371EDE16D&displaylang=en

...and it works! (ODBC connection call from a Perl script using the 64-bit version of Perl).

Maknash · Answer

Hi, I have the same problem actually I tried to check the configuration but apparently I'm compiling correctly with the x86 version.
My issue is explained in more detail here: https://forums.commentcamarche.net/forum/affich-19482405-odbc-pilote-access-2010
EDIT: I found the answer:
The 32-bit version of the Odbcad32.exe file is located in the %systemdrive%\Windows\SysWoW64 folder.

Source: https://support.microsoft.com/fr-fr/help/942976/odbc-administrator-tool-displays-both-the-32-bit-and-the-64-bit-user-d

I was thinking that the best thing would be to pretend to be deaf-mute.
The speed of light is faster than that of sound, which is why we appear smart before we appear dumb.

othmaneMoujahid · Answer

Hi   I had the same problem, and I found a solution to fix it: Start --> Run --> cmd and type the following command: c:\windows\syswow64\odbcad32.exe  That's all

veg · Answer

You need to take odbc 32.exe and configure the system data source instead of the user data source. If you go to odbc 64 DSN system, you won't find what you did with 32 compared to using 32 user DSN. ODBC 32 is located in syswow32.

mat444 · Answer

If it still doesn't work for you, try running the application as an administrator; it only works for me this way!

omar · Answer

You must first install the 32-bit JDK, then the answer is in this video http://youtu.be/tKa7Uvk4w0Y

grx_jn · Answer

It's pretty pathetic that Microsoft is unable to provide the 64-bit ODBC driver for Access in Windows...
We're forced to do everything in 32-bit while we have a 64-bit OS, a 64-bit application, and a 64-bit database... but the driver doesn't exist!

kele · Answer

thank you

coursdinfo · Answer

This topic is a bit old, but for your information,
on a 64-bit PC, Office installs in the 32-bit folder (if Office is 32-bit) and thus, the folder name is Program Files (x86). However, Oracle cannot return data to a folder whose name contains parentheses.
The only solution is either to rename the folder or to reinstall Office in a folder without parentheses.

Microsoft Access ODBC Driver 64-bit

18 answers

Webcam connected to my usb on crosscall axtionx5

Applied pirate

Is your ebay account banned?

Pin code (windows hello)

Convert images with the .heic extension to jpg?

Your smartphone, an overlooked universal remote

Openoffice problem

Pc that freezes all the time

Message about "new ways to communicate"

Openoffice calc