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 ADODB.Connection...Provider cannot be found... 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.