I have a routine which connects to MySQL database with ADODB connection. This worked in 2003 and 2007 runtime but throws a 430 error on 2010 runtime.
Error 430: Class does not support Automation or does not support expected interface
It works in full access 2010. Has there been a change of policy to restrict this type of connection in the 2010 runtime?
If I use a linked ODBC table instead of ADODB the runtime fails with "Runtime Error". It still works in full access.
Any ideas would be gratefully accepted.