For people who are interested in a more fluid, two-way data exchange, Autodesk also provides a free tool for subscription owners, called Revit DB Link. This tool permits both an import and an export and can be used for a wider variety of tasks. A common usage might include editing volumes of Room- or Space-based parameters within Access and then importing the changes back to Revit. I should clarify that this tool does not permit a “live link” between Revit and Access, meaning that both the import and the export processes within Revit are manual. It should also be noted that for 64-bit users, the setup for the MS Access will require a 64-bit ODBC driver which wasn’t provided by Microsoft until the release of Office 2010. You can learn more about the setup on this 2010 Typepad Blog (recent Autodesk posts imply that this information is still valid).
Ideate BIMLink also provides and import/export capability but is aimed at the average user who does not want to setup an Access database or who has found that the Revit DB Link tool cannot manage the volume or type of data needed for a specific task. Excel provides a simple and elegant way to manage the large volumes of data within the Revit project. This chart explains some of the differences between Revit DB Link and Ideate BIMLink.
Now, back to the question at hand… can you use Ideate BIMLink with MS Access? You can, here’s how: http://www.screencast.com/t/ayYInfVSg. I think the primary reason you might consider this workflow is that Ideate BIMLink lets you deal with smaller chunks of data and, again, does not require Access knowledge. The Revit user or consultant can manage a small chunk of the database within Excel. For example, they could fill out important COBie-related fields for specialty equipment items then handover that chunk of Excel-based data for incorporation into the larger, Access database. Ideate BIMLink uses the Type and Instance IDs as the database “key” to help coordinate the information between the Building Model and the database model. It’s the right tool for keeping it simple and fast.
