Runtime 2010 ADODB Connection failure

[SteveDurham]

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.

[boblarson]

It may have to do with the Windows 7 SP1 or Office 2010 SP1. ADO keys changed and so it has to be compiled on a machine with the applicable OS and Office installation. So in other words, if you compile on a machine with either of those SP1's then try to run it on say a Windows XP or Windows Vista machine that doesn't have Office 2010 SP1, then it will fail unless you compile on that machine.

So does any of that apply to you?

[SteveDurham]

Hello Bob,

Things are going from bad to worse. Runtime now tells me to delete the VBA Project because it cannot read it. This worked fine before! Both systems have the latest updates. One is Windows 7 and the Machine with runtime is XP. The runtime will run accdb but not accde.

[rpeare]

I'm assuming you're building an installation package with your run time version? Are you identifying all the references that are needed in your installation package? They do not automatically inherit the references that your original database has you have to specifically tell it which ones you want.

[boblarson]

Hello Bob,

Things are going from bad to worse. Runtime now tells me to delete the VBA Project because it cannot read it. This worked fine before! Both systems have the latest updates. One is Windows 7 and the Machine with runtime is XP. The runtime will run accdb but not accde.

The problem again is that you can't compile it on Windows 7 with SP1 and expect it to work in the runtime on XP. You will need to either use Windows 7 withOUT SP1 or you will need to use an Access installation on WinXP to compile for the runtime on XP.

[rpeare]

I feel like a fool I totally read over the windows 7. screw the details full speed ahead!