The 'Microsoft.Ace.OLEDB.12.0' provider is not registered on the local machine RRS feed

  • Question

  • I have Win7 64 bit and Office 2007 32 bit. I'm trying to connect to access database througb vb.net and I receive this error:

    The 'Microsoft.Ace.OLEDB.12.0' provider is not registered on the local machine

    There are many articles in the forums but there are mentioned for Win764 bit with Office 64 bit (not Office 32bit)

    Do you have any idea?

    I use the following code:

    Public Function ConnectToAccessDatabase(ByVal strMDBFile As String) As Boolean

    Dim connectionString As String

    connectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Password='';Driver=Microsoft Access Driver;User ID=ana;Data Source=" & strMDBDatabasesPath & strMDBFile & " ;Persist Security Info=True;Jet OLEDB:System database=" & strMDWSystemPath & strMDWSystemFile

    cnnAccess = New OleDbConnection(connectionString) Try cnnAccess.Open() MsgBox("Connection Open ! ") Return True Catch ex As Exception MsgBox("Can not open connection ! ") Return False End Try End Function

    Friday, June 15, 2012 6:11 AM

All replies

  • Did you ever manage to get a fix for this as I am having exactly the same problem?


    Monday, July 2, 2012 10:21 AM