"The Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine." Exception is thrown while trying to run forms. eg purchases form

Question

I've been trying to connect a Microsoft access database file to my Visual Basic application. When i try to run the application i get an error: "The Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine" i am using microsoft visual basic 2012.

 Public Class purchases

    Private Sub Purchases_fileBindingNavigatorSaveItem_Click(sender As Object, e As EventArgs) Handles Purchases_fileBindingNavigatorSaveItem.Click
        Me.Validate()
        Me.Purchases_fileBindingSource.EndEdit()
        Me.TableAdapterManager.UpdateAll(Me.TNJ_Retail_Management_SystemDataSet)

    End Sub

    Private Sub purchases_Load(sender As Object, e As EventArgs) Handles MyBase.Load
        'TODO: This line of code loads data into the 'TNJ_Retail_Management_SystemDataSet.Purchases_file' table. You can move, or remove it, as needed.
        Me.Purchases_fileTableAdapter.Fill(Me.TNJ_Retail_Management_SystemDataSet.Purchases_file)

    End Sub
End Class  

Check link for screenshot of output. 1

Does anyone have any idea?

Answer 1

Was able to correct the error simply by downloading Microsoft Access Database Engine and installing it in my PC. I then opened my project, rebuild it and run. Gave expected results. Click here to open site to download the Microsoft Access Database Engine