ADODB.Connection...Provider cannot be found VBA

Hi there,

The company that I work for have just updated to SW 2017 x64 from 2011 x64. We are on Windows 2007 x64

When trying to connect to Microsoft Access 2010 x32 I get an error "3706 Provider cannot be found".

I have read the post which is the same issue as myself.

Dim conn As ADODB.Connection

Set conn = New ADODB.Connection

strConn = "Provider=Microsoft.Ace.OLEDB.12.0;Persist Security Info=False;" & "Data Source=" & GetReportsDB & ";"

conn.Open strConn - ERRORS ON THIS LINE

I have also tried a reference to Microsoft ActiveX Data Objects 2.8 Library which did not work

Does anyone know a work around for this issue?

Also on the discussion, there was a post by someone called Frank 1-1S26RY.

He added a link to a presentation. The link does not work unfortunately.

Does anyone have an update for this or know where I can get it from?

Thanks for your time. Any help would be grateful.

Declan