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:
http://www.microsoft.com/download/en/details.aspx?id=13255
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!
Enjoy.