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
