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

Recommended Answers

All 2 Replies

umm... I would try setting the target processor higher

infact that fixed the problem when I had it

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.