Can someone tell me if it is possible to generically connect to MS Access?
Originally, when my users were on Access 2003, I used
and then when they upgraded to Access 2007, I had to change it to this...
However, it seems that if someone using Access 2003 uses the new version - they get an error
"The Microsoft.ACE.OLEDB.12.0'provider is not registered on the local machine"
I assume that this is because the support isn't installed, as it clearly didn't exist in 2003...
Is there anything I can do to allow use of different versions of MS Access?
Thanks!
-Justin
Originally, when my users were on Access 2003, I used
VB.NET:
strMSAccess_Connection_SQL = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & strDatabaseFilePath
MSAccess_Connection = New OleDbConnection(strMSAccess_Connection_SQL)
and then when they upgraded to Access 2007, I had to change it to this...
VB.NET:
strMSAccess_Connection_SQL = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" & strDatabaseFilePath
MSAccess_Connection = New OleDbConnection(strMSAccess_Connection_SQL)
However, it seems that if someone using Access 2003 uses the new version - they get an error
"The Microsoft.ACE.OLEDB.12.0'provider is not registered on the local machine"
I assume that this is because the support isn't installed, as it clearly didn't exist in 2003...
Is there anything I can do to allow use of different versions of MS Access?
Thanks!
-Justin