Hi
My application currently works with Access 2003 using the following approach...
When I load it onto a WinVista machine running Office 2007, I get the following error
I was doing a little research and I guess 2007 changed a few things? Introduced something called ACE? I tried using
but I get a similar error to the above...
Thoughts?
Many thanks!
-Justin
My application currently works with Access 2003 using the following approach...
VB.NET:
strMSAccess_Connection_SQL = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & strDatabaseFilePath
MSAccess_Connection = New OleDbConnection(strMSAccess_Connection_SQL)
MSAccess_Connection.Open()
When I load it onto a WinVista machine running Office 2007, I get the following error
VB.NET:
the microsoft.jet.oledb.4.0 provider is not registered
I was doing a little research and I guess 2007 changed a few things? Introduced something called ACE? I tried using
VB.NET:
"Provider=Microsoft.ACE.OLEDB.12.0", etc
but I get a similar error to the above...
Thoughts?
Many thanks!
-Justin