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