ADO.Open crashes Excel 2010

Question

ADO.Open crashes Excel 2010

reinht 21

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

reinht 21

A correction! Code needs to be:

'\Reference: Microsoft ActiveX Data Object 6.1 Library
Sub Excel2010Crash()
  Dim CN As ADODB.Connection
  Set CN = New ADODB.Connection

  '\This line will crash Excel 2010
  CN.Open "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Users\JohnDoe\Documents\AnyDatabase.accdb"

End Sub

1 answer

Your answer

reinht 21 Reputation points

2021-08-21T11:26:07.773+00:00

A correction! Code needs to be:

'\Reference: Microsoft ActiveX Data Object 6.1 Library Sub Excel2010Crash() Dim CN As ADODB.Connection Set CN = New ADODB.Connection '\This line will crash Excel 2010 CN.Open "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Users\JohnDoe\Documents\AnyDatabase.accdb" End Sub

Answer 1

Castorix31 90,686

From Google, there are threads about the connection string, like :
Excel 2010 crashes when attempting to open ADODB.Connection

reinht 21 Reputation points

2021-08-21T11:32:16.753+00:00

This workaround is not working for *.accdb files!

Share via

ADO.Open crashes Excel 2010

1 answer

Your answer