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