question

B66E31-3176 avatar image
0 Votes"
B66E31-3176 asked emizhang-msft commented

EXCEL 2016 + ADOMySQL : automation error specified module could not be found

Hello,
Following a migration of database from MySQL server 5.0.68 to 8.0.26, I tested existing xlsm files.

On old Win10 user stations equipped with Office 2007 or 2010, no problem, the old macros have all run well with the mysql-connector-odbc-8.0.26-win32.msi driver and the new MySQL server 8.

But on the new PC Win10 + Office2016, we have the msgBox: "The method 'Open' of the object '_Connection' has failed", correspondind to the detailed error:
: Description : "automation error specified module could not be found." String: ADOMySQL.OpenConnection

I checked the additional macros and the VBA references used, they are identical on the old and new computers.

The driver is well installed in Win64 and Win32 for security; and checked via odbcad32.

I've tried to repair Office as advised on this forum but no success.

If anyone has an idea, I'm interested because I don't have any more...

office-excel-itprooffice-scripts-excel-dev
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

emizhang-msft avatar image
0 Votes"
emizhang-msft answered emizhang-msft commented

Hi @B66E31-3176,
It seems the ODBC is not available in Office 2016.
Did the Windows 10 use 64-bit version? Windows 10 64-bit version didn't install Access 64-bit ODBC driver default.
Did your Office 2016 suite contain Access?
If not, I suggest you install the Access 2016 Runtime:
https://www.microsoft.com/en-us/download/details.aspx?id=50040

Try this method and check the result, any updates please let me know and I'm glad to help you.


If the response is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.




· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @B66E31-3176,
Just checking in to see if the information was helpful. Please let us know if you would like further assistance.

0 Votes 0 ·