My Excel VBA application has to run from Excel 2010. But recently the following code will crash Excel 2010. Excel 2019/365 is working.
'\Reference: Microsoft ActiveX Data Object 6.1 Library
Sub Excel2010Crash()
'\This line will crash Excel 2010
ADODB.Connection.Open "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Users\JohnDoe\Documents\AnyDatabase.accdb"
End Sub
"C:\Program Files (x86)\Common Files\System\ado\msado15.dll" is version 10.0.19041.746.
Any ideas to overcome this issue?
TIA
Reinhard
