Migrating VBA macros from ACAD 2010 to 2018, connection to Access DB's

[Anonymous]

I have several "OLD" VBA macros that connect to Access DB's that I am trying to migrate to ACAD 2018 in Win7 first then to Win10. MS Office 2010 is also installed. The macros reference MS DAO 3.6 Object library, however the dao360.dll file it is trying to use is pointing to a folder (C:\Program Files\Common Files\Microsoft Shared\DAO) that does not exist. When I browse to the correct folder (C:\Program Files (x86)\Common Files\Microsoft Shared\DAO), the location/file will not be listed. This prevents me from referencing the dll correctly.

I am suspicious that the needed dll is not registered or I need to install something else.

Side Note: ACAD2010 on Win7 connecting to MS Access 2010 works fine.

Any help would be greatly appreciated.

Ray C.

[dgorsman]

Let me guess: you have x32 Office and x64 AutoCAD installed?

[Anonymous]

Yes, it is.

[Ed__Jobe]

---

@Anonymous wrote:

Yes, it is.

---

64 bit can't talk to 32 bit Office. That's why I migrated away from Access to SQLExpress.

[Anonymous]

First let me say I miss-typed. Our ACAD version is 2012, the macros originated for use with ACAD 2010.

Your comment about 64 bit can't talk to 32 bit is confusing. We are currently running ACAD 2012 64bit and accessing MS Access 2010 32 bit as in my original comment.

If ACAD 2018 64bit with VBA is different and won't work with 32 bit Access then I will need to regroup. But it is hard for me to believe there is not a way to get them to talk to each other.

[JTBWorld]

It is correct that this is the cause of the prolem. Install office 64-bit is the easiest solution unless you change to use SQL Server or SQL Server Express.

[axemanjon]

Hi

We use old Access DBs and usually experience this problem with fresh installs - the VBA reference to Microsoft DAO 3.6 Object Library is the issue for us.

I've solved it for users by finding DAO360.dll in C:\Program Files (x86)\Common Files\microsoft shared\DAO\ and copying it to C:\Windows\SysWOW64\ which stops execution errors.