Solved

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

Posted on 2011-03-21
6
1,660 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
Back Up Your Microsoft Windows Server®

Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

 
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

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

My attempt to use PowerShell and other great resources found online to simplify the deployment of Office 365 ProPlus client components to any workstation that needs it, regardless of existing Office components that may be needing attention.
If you need a simple but flexible process for maintaining an audit trail of who created, edited, or deleted data from a table, or multiple tables, and you can do all of your work from within a form, this simple Audit Log will work for you.
This Micro Tutorial will give you a introduction in two parts how to utilize Windows Live Movie Maker to its maximum editing capability. This will be demonstrated using Windows Live Movie Maker on Windows 7 operating system.
The Task Scheduler is a powerful tool that is built into Windows. It allows you to schedule tasks (actions) on a recurring basis, such as hourly, daily, weekly, monthly, at log on, at startup, on idle, etc. This video Micro Tutorial is a brief intro…

695 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