Solved

Access 2010: ODBC connection driver is missing, won't reinstall.

Posted on 2011-03-21
6
1,641 Views
Last Modified: 2012-05-11
One of my customers had installed Access 2010, 64 bit on Windows 7 64 bit.

It turned out that one of their software packages needed the 32 bit version in order to use ODBC otherwise it was giving an architecture mismatch error.

i had uninstalled the 64 bit version of access, reinstalled the 32 bit version of access and everything seemed fine as far as the odbc connection working from the 3rd party application.

However, i cannot edit the existing ODBC connection due to the following error:

the setup routines for the microsoft access driver (*.MDB, *.accdb) ODBC driver could not be found. Please reinstall the driver.

I also can't remove it due to that error, if i try to add a new connection access is missing from the options, it's also not listed on the drivers tab.

i have tried uninstalling/reinstalling access both 32 bit and 64 bit several times without it reinstalling.
Access is not listed under drivers in ODBC connections.

i also tried installing the 32 bit access database engine which that said it provided what was necessary for odbc connectivity but that doesn't work either. it looks like it installs OK but there is no access driver listed in ODBC connections.

Does anyone know how i can get the access 32 bit ODBC connection driver reinstalled?
One thing i have thought of is that i did not remove the ODBC connection before i uninstalled access x64 and reinstalled x32.

I tried going in to the registry and in the user's HKCU\software\ODBC and manually removing the problematic odbc connections, uninstall and reinstall access hoping that would let it show up but it's still not installed.



thanks!

0
Comment
Question by:jspaziano
  • 3
  • 2
6 Comments
 
LVL 8

Expert Comment

by:infolurk
ID: 35185777
Have a look at http://support.microsoft.com/kb/942976
It explains quite well where the 32 and 64 bit ODBC drivers are located, what they do and what they can't do.

Try running the 64 bit ODBC connection manager that lives at %systemdrive%\Windows\System32\Odbcad32.exe to edit the 64 bit system DSN.

Cheers
Steve
0
 
LVL 2

Author Comment

by:jspaziano
ID: 35185792
it's not listed in either the 32 or 64 bit connection manager.

when reviewing the ODBC connection that was already created and the DLL for the odbc connection that is referenced, that file doesn't exist where it's supposed to.

it seems the access installer just isn't installing the needed odbc driver for some reason.

0
 
LVL 2

Author Comment

by:jspaziano
ID: 35185806
i also went in to the user DNs which is where the odbc connection was created and maunally removed it thinking maybe it was hanging up the installer from reinstalling the driver but that did not help.
0
Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

 
LVL 23

Accepted Solution

by:
OP_Zaharin earned 500 total points
ID: 35185807
hi jspaziano,

-can you look into C:\Windows\SysWow64 if this folder exist and if odbcad32.exe file exist in that folder. run this 32-bit version of ODBC admin instead of the 64-bit in the Control Panel.
0
 
LVL 23

Expert Comment

by:OP_Zaharin
ID: 35185934
- also try to install the Microsoft Access Database Engine 2010 Redistributable
http://www.microsoft.com/downloads/en/details.aspx?FamilyID=c06b8369-60dd-4b64-a44b-84b371ede16d

- search for odbcad32.exe in Windows folder if the C:\Windows\SysWow64 does not exist. And use this 32-bit admin to create your DSN.
0
 
LVL 2

Author Comment

by:jspaziano
ID: 35185950
thanks.

i wound up installing the 32 bit version on another system and manually copying the file where it was looking for it.

then i was able to use the 32 bit version of odbc admin and all was well.

0

Featured Post

Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

By default the complete memory dump option is disabled in windows . If we want to enable the complete memory dump for a diagnostic purpose, we have a solution for it. here we are using the registry method to enable this.
On some Windows 7 (SP1) computers, Windows Update becomes super slow even the computer is reasonably fast.  There's one solution that seemed to have worked well for me (after trying a few other suggested solutions).
This Micro Tutorial will give you a basic overview of Windows Live Photo Gallery and show you various editing filters and touches to photos you can apply. This will be demonstrated using Windows Live Photo Gallery on Windows 7 operating system.
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

813 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now