Need to download the ODBC Driver for Microsoft Access Database.
Posted on 2008-06-17
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?