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

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

Anonymous — Tue, 11 Sep 2018 13:30:56 GMT

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.

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

dgorsman — Tue, 11 Sep 2018 14:03:38 GMT

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

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

Anonymous — Tue, 11 Sep 2018 14:15:27 GMT

Yes, it is.

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

Ed__Jobe — Tue, 11 Sep 2018 14:37:04 GMT

@Anonymous wrote:

Yes, it is.

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

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

Anonymous — Tue, 11 Sep 2018 15:06:51 GMT

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.

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

JTBWorld — Tue, 11 Sep 2018 16:04:13 GMT

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.

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

axemanjon — Thu, 17 Jan 2019 14:31:58 GMT

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.