topic Re: How to create DB Link to MS Access? in Revit Architecture Forum

How to create DB Link to MS Access?

Anonymous — Thu, 24 Aug 2017 02:29:28 GMT

I have already installed Revit DB Link and also MS Access 2007 on my desktop but It's seem to be no connection between Revit and MS Access ("Select a New connection" button is disappear) ... any one how to fix this issue ?

PS. I've tried using Export > ODBC and set up an Access Connection but this seem to be very complicated and I cannot get it right.

Re: How to create DB Link to MS Access?

ToanDN — Thu, 24 Aug 2017 03:18:57 GMT

You need Access 2010 64 bit as the minimum.

Re: How to create DB Link to MS Access?

Anonymous — Thu, 24 Aug 2017 08:29:28 GMT

Yes, the Access I got is already 2016 version.

Any Solution on this ?

Re: How to create DB Link to MS Access?

ToanDN — Thu, 24 Aug 2017 21:10:17 GMT

I am not familiar with Excel 2016, is it the 64-bit version? I only have Excel 2010 64-bit and it works fine. Maybe you need to downgrade.

Re: How to create DB Link to MS Access?

Anonymous — Fri, 25 Aug 2017 01:49:07 GMT

I have to install MS Access Runtime 2010 and then it somehow work!!

Thanks for your hint @ToanDN