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.

http://www.solidworks.com/sww/proceedings/proceedings-presentations.htm 

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

 

 

Outcomes