So, apparently when Microsoft split their programs between 64 and 86 bit, the ODBC Drivers took a hit. So instead of the traditional manner of going to Control Panel > System and Security > Administrative Tools > Device Drivers (ODBC) > Add (in the User DSN tab). Instead go to C:\Windows\sysWOW64\odbcad32.exe > Add > Microsoft Access Driver (*.mdb) > After putting in your own names for the Data Source Name and Description > Select; find your database on your local computer and go ahead and add that. Bit confusing, but luckily I found http://answers.microsoft.com/en-us/office/forum/office_2007-excel/no-odbc-drivers-available-for-excel-or-access-in/001c234b-dfd5-4378-a325-c4f1482fb6fd online on my first Google search (thank goodness for Google! and Microsoft answers!).
Now I'm going back to configuring my system for "data basing with Java" class. Happy Valentine's day.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment