by Joe Eichenseer
How many of you have run into this and found a dead end? You are using a 64-bit workstation (Windows 7, probably) with 64-bit version of some Autodesk software (Revit or Navisworks, perhaps) and want to try out this supposedly nifty neato cool wow export/link to Microsoft Access. You might have run into a problem in that as you work through any export/link wizard, you don't see any way to export to MS Access.
- Your Autodesk software is 64-bit, so it needs a 64-bit ODBC (Open Database Connectivity) driver.
- Your Microsoft Office is 32-bit and has 32-bit drivers available (although tricky to find), but as mentioned above, these won’t work with 64-bit applications.
- If you have 32-bit MS Office, it will not let you install a 64-bit ODBC driver.
Translation: you’re in a sticky situation. But fortunately, there is a resolution to this one.
It all boils down to just a few steps, but you’ll need to make sure that you have all of the resources you’ll need prior to starting the process. For starters, you’ll need to download the 64-bit MS Access ODBC drivers from Microsoft here:
Be sure to grab the 64-bit (AccessDatabaseEngine_x64.exe) version! :)
You will also need to have your MS Office media available – or have some way available for you to reinstall MS Office. Once you have these pieces in place, you have a 3 or 4 step process in front of you:
- Uninstall Microsoft Office and any other versions of 32-bit Office products that are installed.
- Uninstall "Microsoft Access Database Engine 2010 Redistributable 32-bit" if you installed it at some point in the past.
- Install the Microsoft Access Database Engine 2010 Redistributable 64-bit that you downloaded from the link above. Because all of your 32-bit office products were uninstalled, you should not receive any error messages during the install of the 64-bit drivers.
- Reinstall Microsoft Office (and any other 32-bit Office products).
After this, you should be able to export from your 64-bit Autodesk application to MS Access and get rolling with figuring out what you might want to do with SQL strings or whatever destination your journey into databases takes you!