Need to download the ODBC Driver for Microsoft Access Database.

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
LVL 10
P1ST0LPETEAsked:
Who is Participating?
 
Rey Obrero (Capricorn1)Commented:
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 ...

0
 
Rey Obrero (Capricorn1)Commented:
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..
0
 
P1ST0LPETEAuthor Commented:
That's the only way to download the driver - to reinstall?
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
anmalaverCommented:
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...
0
 
P1ST0LPETEAuthor Commented:
What do you mean by "corresponding .jar for your project" ?
0
 
anmalaverCommented:
You should download and use the jar driver to connect to your DB
What IDE do you use?
0
 
mrcoffee365Commented:
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.
0
 
P1ST0LPETEAuthor Commented:
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.
0
 
mrcoffee365Commented:
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

0
 
jkurznerCommented:
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???
0
 
mrcoffee365Commented:
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.
0
 
jkurznerCommented:
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.
0
 
P1ST0LPETEAuthor Commented:
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?
0
 
P1ST0LPETEAuthor Commented:
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."
0
 
mrcoffee365Commented:
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
0
 
jkurznerCommented:
Service Packs are all updated.  None of the Jet 4 SP8 will run since it is for a different platform than XP64bit.  This sucks
0
 
jkurznerCommented:
nope
0
 
mrcoffee365Commented:
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?
0
 
mrcoffee365Commented:
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.
0
 
janthamattenCommented:
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.
0
 
mrcoffee365Commented:
Cool -- thanks for the thanks!  Isn't EE great?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.