Question

Need to download the ODBC Driver for Microsoft Access Database.

Asked by: P1ST0LPETE

Hi All,

This should be an easy one, but I'm running out of time and need this asap.  I need to download the Microsoft Access ODBC Driver so that I can set up a User DSN that my Java programs can connect too.  I was shocked when I went into Control Panel >>> Administrative Tools >>> Data Sources (ODBC),  and when I went to add a new DSN there were no drivers!  I have Access 2003 installed and working properly, and even on the list of already set up DSN's it shows:

dBASE Files...................Microsoft Access dBASE Driver (*.dbf, *.ndx, *.mdx)
Excel Files......................Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb)
MS Access Database....Microsoft Access Driver (*.mdb, *.accdb)

However, if I try clicking on any of those to configure them I get a popup window error saying, "The setup routines for the Microsoft Access Driver (*.mdb, *.accdb) ODBC Driver could not be found.  Please reinstall the driver."  I click ok, and then another popup error window says "Component not found in registry."  Is this common for the drivers not to be there, when you have Access installed?

Anyway, where can I find and download the latest MS Access ODBC Driver for MS Access 2003?

Thanks

This Question has been solved and asker verified All Experts Exchange premium technology solutions are available to subscription members.

Subscribe now for full access to Experts Exchange and get

Instant Access to this Solution

  • Plus...
  • 30 Day FREE access, no risk, no obligation
  • Collaborate with the world's top tech experts
  • Unlimited access to our exclusive solution database
  • Never be left without tech help again

Subscribe Now

Asked On
2008-06-17 at 15:45:47ID23493511
Tags

Microsoft

,

Access

,

2003

Topics

Microsoft Access Database

,

Java Programming Language

Participating Experts
5
Points
500
Comments
24

Trusted by hundreds of thousands everyday for fast, accurate and reliable tech support.

  • "The time we save is the biggest benefit of Experts Exchange to Warner Bros. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange." Mike Kapnisakis, Warner Bros.
  • "Our team likes having a resource that is more secure than just using Google and most experts using this service really know their stuff. It's nice to look here first versus using Google." Dayna Sellner, Lockheed Martin
  • "Anytime that I've been stumped with a problem, 9 out of 10 times Experts Exchange has either the accepted solution or an open discussion of the potential solution to the problem." Kenny Red, eBay Inc.

See what Experts Exchange can do for you.

Got a question?

We've got the answer.

Experts Exchange has been collecting answers to technology questions since 1996…3 million and counting! If you have a question, chances are we already have your answer.

Screenshot of Experts Exchange Knowledgebase

Need individual assistance?

Our experts are ready to help.

If you can't find the exact answer you're looking for, ask our exclusive community of 50,000 experts. You’ll get a personalized answer from a trusted professional.

Screenshot of Experts Exchange Knowledgebase

Want to learn from the best?

Read articles from industry experts.

Thousands of free tech tips, tricks, how-to’s and tutorials are available in our peer reviewed articles section. See for yourself how smart our experts are, no login required.

Screenshot of an Article

Working on a long term project?

Store your work and research.

Save solutions to your questions, answers you’ve discovered through searching plus helpful articles in your personal knowledgebase for easy future access.

Screenshot of Experts Exchange Knowledgebase

Access the answers to your technology questions today.

Subscribe Now

30-day free trial. Register in 60 seconds.

What Makes Experts Exchange Unique?

Members of the expert community talk about why the experience at Experts Exchange is different than what you will find anywhere else.

Trusted by the world's most respected brands.

image of each brand's logo

Faithfully serving IT professionals since 1996.

Experts Exchange Logo

Try it out and discover for yourself.

Subscribe Now

30-day free trial. Register in 60 seconds.

Related Solutions

  1. Using DBase III With ODBC
    Hello All. I've got a number of DBase III (*.dbf) files i wish to use for my net page. I've previously used MS Access which worked 150% perfectly. My problem is this. I've got the following files -> stock.dbf, orders.dbf and clients.dbf. I also have the following...
  2. ODBC - Clipper DBF - NTX
    Where can i get an ODBC driver that will read DBF files with NTX intexes. Microsoft's DBASE driver will read .ndx indexes only. Doug
  3. ODBC, DSNLess and a dBase database
    I'm trying to open a DBF file via ODBC without using a DSN entry. Is this possible? Does anyone have any example code of how to achieve this? What should the connection string look like? I'm using DAO 3.51 and a dBase IV database. Thanks in advance...
  4. Create index for DBF from ODBC
    I want to create index for DBF file using ODBC. When I put command create index myindex on mytable (myfield) I receive message "Operation for this object is not supported" I use PowerDesigner9 and type all the commands in its "Execute SQL" window. ODB...

Free Tech Articles

  1. WARNING: 5 Reasons why you should NEVER fix a computer for free.
    It is in our nature to love the puzzle. We are obsessed. The lot of us. We love puzzles. We love the challenge. We thrive on finding the answer. We hate disarray. It bothers us deep in our soul. W...
  2. SCCM OSD Basic troubleshooting
    SCCM 2007 OSD is a fantastic way to deploy operating systems, however, like most things SCCM issues can sometimes be difficult to resolve due to the sheer volume of logs to sift through and the dispe...
  3. Migrate Small Business Server 2003 to Exchange 2010 and Windows 2008 R2
    This guide is intended to provide step by step instructions on how to migrate from Small Business Server 2003 to Windows 2008 R2 with Exchange 2010. For this migration to work you will need the fo...
  4. Create a Win7 Gadget
    This article shows you how to create a simple "Gadget" -- a sort of mini-application supported by Windows 7 and Vista. Gadgets can be dropped anywhere on the desktop to provide instant information, ...
  5. Outlook continually prompting for username and password
    There have been a lot of questions recently regarding Outlook prompting for a username and password whilst using Exchange 2007. There are a few reasons why this would happen and I will try to cover t...
  6. Backup Exchange 2010 Information Store using Windows Backup
    There seems to be quite a lot of confusion around the ability to backup Exchange 2010 using the built in Windows Backup feature. This stems from the omission of this feature prior to Exchange 2007 s...

Cloud Class Webinars

  1. Avoiding Bugs in Microsoft Access
    Alison Balter takes and in-depth look at avoiding bugs in Access. In this webinar you will learn about using the immediate window to debug your applications, invoking the debugger, using breakpoints to troubleshoot, stepping through code, setting the next statement to execute, ...
  2. Top 10 Best New Features in Visio 2010
    Scott Helmers gives live demonstrations of the top 10 new features in Visio 2010. This webinar will teach you how to create compelling diagrams by adding shapes to the page with a single click, linking the shapes in a diagram to data in Excel (or SQL Server, or SharePoint), ...
  3. IT Consultant Business Secrets Revealed
    Michael Munger, Experts Exchange tech pro and IT consultant, pulls back the curtain on his very successful businesses and answers question on every IT consultant and business owner should know about. He shares secrets on what he did to solve the 5 most common problems in IT, ...
  4. Disaster Recovery and Business Continuity
    Quest CTO, Mike Billon, gives an overview of the steps involved in building a dunamic disaster recovery plan. Through case studies and an examination of software/hardware tooles for monitoring and testing, you'll gain a better understandin of where you are, where you want ...
  5. Organize Your Visio Diagrams with Containers and Lists
    Scott Helmers uses cross functional flowcharts, wireframe diagrams, data graphic legends and seating charts to teach you: how to ustilize all three new structured diagram components in Visio 2010, the best practices for organizeing shapes in previous version of Visio, how to organize ...
  6. How to Us Objects, Properties, Events and Methods in Microsoft Access
    Alison Dalter gives an in-depbth look at objects, properties, events and methods in Microsoft Access. In this webinar you will learn about using the object browser, referring to objects, working with properties and methods, working with object variables, understanding the ...

Join the Community

Give a Little. Get a Lot.

Join the community of experts here and help other tech pros by answering question in your area of expertise. You can earn FREE access to all Experts Exchange's premium features and resources.

Join the Community

Answers

 

by: capricorn1Posted on 2008-06-17 at 15:56:19ID: 21808148

you should only see

Microsoft Access Driver (*.mdb)
not

Microsoft Access Driver (*.mdb, *.accdb) the *.accdb is for access2007


you may have to remove the Office 2003 from Control Panel >add remove Program

and re install..

 

by: P1ST0LPETEPosted on 2008-06-17 at 17:06:26ID: 21808595

That's the only way to download the driver - to reinstall?

 

by: anmalaverPosted on 2008-06-17 at 17:25:05ID: 21808685

Hi

Look at this link and get the corresponding .jar for your project.
http://developers.sun.com/product/jdbc/drivers

Write back if you have problems...

 

by: P1ST0LPETEPosted on 2008-06-17 at 17:29:27ID: 21808709

What do you mean by "corresponding .jar for your project" ?

 

by: anmalaverPosted on 2008-06-17 at 18:10:55ID: 21809013

You should download and use the jar driver to connect to your DB
What IDE do you use?

 

by: mrcoffee365Posted on 2008-06-18 at 06:32:45ID: 21812640

You don't need a jar to use the JDBC-ODBC connection to an Access db.  Your question is about the ODBC driver, which -- if it isn't there -- probably means that you have to re-install Access.  It's very strange that you have Access installed on your machine, but you can't configure the ODBC listing for an Access db.  We've never run into that on any of our machines.

 

by: P1ST0LPETEPosted on 2008-06-18 at 07:13:48ID: 21813087

Yeah I find it very strange as well, having Access installed yet no ODBC driver.  Due to the short time frame I'm under, I opted to just switch to a different machine that had the ODBC driver.

 

by: mrcoffee365Posted on 2008-06-18 at 10:21:12ID: 21815031

Ah -- maybe you never got the MDAC installation?  I thought it came with Access 2003, but maybe you still have to install it separately.  You can get it here:
http://www.microsoft.com/downloads/details.aspx?FamilyID=6c050fe3-c795-4b7d-b037-185d0506396c&displaylang=en

 

by: jkurznerPosted on 2008-06-19 at 08:26:38ID: 21823133

This is the exact thing happening to me.  I had Office 2003 on the machine for Front Page and Visio as well as Office 2007 Ultimate.  For some reason I see the Access driver on the system tab but no where else.  I cannot open or configure it.  I removed all of the Office 2003 components and opened Access 2007.  It did an installation notice upon opening, but works just fine.  I went back to the ODBC administrator and still can't create an Access ODBC data source.  This is very frustrating. How the heck am I supposed to reinstall a driver that is installed???

 

by: mrcoffee365Posted on 2008-06-20 at 14:54:04ID: 21835215

Did you try getting the MDAC driver from Microsoft?  Go to the link I posted above.  Once it installs, you'll have the ODBC drivers for MS Access.

 

by: jkurznerPosted on 2008-06-20 at 18:02:04ID: 21835883

Yep, I've installed those MDAC's several times.  My understanding is that it may be related to the fact that I am running XP 64 bit.  God I hate Microsoft sometimes. Also, I have been told that the 2.8 MDAC doesn't contain the legacy access drivers.

 

by: P1ST0LPETEPosted on 2008-06-20 at 20:58:50ID: 21836279

Quote: My understanding is that it may be related to the fact that I am running XP 64 bit.

I was also thinking this, but was hesitant to mention it at first as I didn't think it was the root of the cause.  I have several laptops and desktops, but my desktop of choice (the machine I was having the problem with) runs Windows XP Pro 64.  All my other machines are 32 bit XP, and have no problem with the access drivers.  Also, as far as MS Office products are concerned, I have only ever installed Office 2003, which referring back to capricorn1s post in this thread, it seems odd that I would have a driver listed for access 2007 (*.accdb).  Could this problem be due to a Microsoft update?

 

by: P1ST0LPETEPosted on 2008-06-20 at 21:04:25ID: 21836294

Quote: "Did you try getting the MDAC driver from Microsoft?  Go to the link I posted above.  Once it installs, you'll have the ODBC drivers for MS Access."

Quoted from: http://www.microsoft.com/downloads/details.aspx?FamilyID=6c050fe3-c795-4b7d-b037-185d0506396c&displaylang=en
"This release does not include Microsoft Jet, the Microsoft Jet OLE DB Provider or ODBC driver, the Desktop Database ODBC Drivers, or the Visual FoxPro ODBC Driver."

 

by: mrcoffee365Posted on 2008-06-20 at 22:51:09ID: 21836526

Ah, you're right.  It turns out that my earlier thinking was correct, the ODBC drivers are installed with Windows XP and above.  I'm assuming you're at least at XP if you're installing Access 2003.

See this discussion on EE, with the same conclusions.  The recommendation is to install a Windows service pack:
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_21342166.html

 

by: jkurznerPosted on 2008-06-21 at 06:29:51ID: 21837497

Service Packs are all updated.  None of the Jet 4 SP8 will run since it is for a different platform than XP64bit.  This sucks

 

by: capricorn1Posted on 2008-06-21 at 07:07:28ID: 21837598

see if this will help

run  C:\WINDOWS\SysWOW64\odbcad32.exe

this should bring the odbc Data source administrator (see if you have the 32 bit drivers listed for Microsoft access )
if you see it, set up your DSN ...

 

by: jkurznerPosted on 2008-06-21 at 07:12:00ID: 21837609

nope

 

by: mrcoffee365Posted on 2008-06-23 at 08:15:02ID: 21847076

So you're running x64 -- that's very useful information.  I see from googling that a lot of people have a similar problem to yours.

This is a discussion thread  which discusses another possible solution.  The expert says that you can use the 32-bit driver or the 64-bit driver.  However, your application may need the 32-bit driver, in which case you have to make sure that the 32-bit driver is before your 64-bit driver in the execution path.
http://forums.techarena.in/showthread.php?t=698703

The quote from the MVP on forum is:
"To setup DSN for 32-bit application you must use:
%WINDIR%\SysWOW64\odbcad32.exe
and for 64-bit application you must use:
%WINDIR%\System32\odbcad32.exe
"

You said "Nope" in response to similar advice from capricorn1 above, but I don't think we can help unless we get more details about what didn't work.  Did the .exe not exist?  Were you able to create the DSN but not connect from your program?  Did you get an error message, and if so, what was it?

 

by: mrcoffee365Posted on 2008-09-21 at 10:07:10ID: 22535316

I think we answered the question, although there continued to be issues.  The asker went away, but I don't think that's a reason to not award points.

 

by: janthamattenPosted on 2009-06-01 at 11:26:52ID: 24520270

I just wanted to say thanks to you all,
Almost a year later and this thread is still quite helpfull!!!!
We have fussed with this issue for two days now and we can put this problem to rest now.

thanks again,
ACCC MIS Dept.

 

by: mrcoffee365Posted on 2009-06-01 at 11:50:57ID: 24520495

Cool -- thanks for the thanks!  Isn't EE great?

20120131-EE-VQP-002

3 Ways to Join

30-Day Free Trial

The Experts

98% positive feedback on 31,087 answers since March 2000. angeliii is a Microsoft Most Valuable Professional for his work with MS SQL Server & Develoment.

He has also proven his knowledge of Visual Basic Programming, PHP Scripting and Oracle Databases.

The Experts

97% positive feedback on 10,752 answers since July 2000. lrmoore has more than 18 years experience in the networking industry.

The six-time Mircosoft MVPs specialties include firewalls, virtual private networking, and network management.

Testimonials

"...and excellent source for support... Kind of like having your very own IT dept." Electriciansnet

Testimonials

"I was apprehensive at signing up at first. However... it has already made my life as an IT administrator much easier." JaCrews

Testimonials

"WOW! You guys have great, active, and knowledgeable people on here." moore50

Business Clients

Business Clients

In the Press

"If you’ve got a question... Experts Exchange can supply an answer.”

In the Press

"...an invaluable aid for both IT professionals and those who require tech support."

In the Press

"where IT professionals provide quick answers on just about any topic"

Business Account Plans

Loading Advertisement...