can someone help me connecting ms access 2010 to visual basic 2008, this is the error of my program every time I run it "The 'Microsoft.ACE.Oledb.12.0' provider is not registered on the local machine."
here is my code for the provider
Imports System
Imports System.Data
Imports System.Data.OleDb
Public Class Form1
Inherits System.Windows.Forms.Form
Dim strconnection = "Provider = Microsoft.ACE.Oledb.12.0;Data Source = C:\Users\Malvin\Documents\Visual Studio 2008\WindowsApplication1\IDsystem.accdb;"
'i create the database on ms access 2007 and now i upgrade my access 2007 to 2010, then the error shows.
thanks in advance..