3 Replies Latest reply on Feb 2, 2017 10:33 AM by Declan Brogan

    ADODB.Connection...Provider cannot be found VBA

    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