VBA PROBLEMS BETWEEN AUTOCAD 2010 64 bit AND ACCESS 2010 32 bit

[Anonymous]

I'm having a problem with Autocad in conjunction with Microsoft Access.

Some time ago, I developed a database that contains parameters and that launches Autocad, in Autocad, I created a VBA project (.DVB) that I load from access then I launch one of the macro of this project " _Sofresid.DVB "(attached file), this macro (LanceAppli) is supposed to read the parameters in a table of the access database and execute some things.

To access the access database tables from autocad, in the autocad dvb project, I used the Microsoft DAO 3.6 (32bit) library, I need to reuse this Autocad dvb project but it no longer supports the DAO 3.6 library (problem when loading into Autocad), so I replaced it with the new access database access library which is microsoft office 14.0 library (32bit) by checking it in the references of the project dvb, until then no problem but when I compile, he tells me that the instructions are not recognized so the library is not recognized or not read.
We have an Autocad 2014 or more in 64bit and on the computers we have Office 2010 or 2016 but 32bit
Will you help me?

[norman.yuan]

Since you are using AutoCAD2014 64-bit (or later), the VBA in AutoCAD is also 64-bit, thus, you cannot access 32-bit MS Access DB engine, which might be installed by MS Office suite. Note, not like older MS Access engine, called Jet Engine, which comes with older Windows OS, Since Access2007, (or 2005, maybe?) MS Access DB Engine would only be installed with MS Access, or separate download/install, if MS Access is not installed.

So, you need to download and install 64-bit MS Access DB Engine to all computers that run the said AutoCAD VBA program. It would be tricky (and even difficult) to install 64-bit MS Access DB Engine, if the computer has older version (2007/2010)of MS Office suite (including MS Access or not).

This topic has been discussed quite a few times in this forum, If you search for "MS Access", you would see many of the past discussion.