AnsweredAssumed Answered

ADODB.Connection...Provider cannot be found VBA

Question asked by Declan Brogan on Jan 17, 2017
Latest reply on Feb 2, 2017 by Declan Brogan

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 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

VBA Referennces.jpg


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.