Access 2007 autoexec macro loading ribbons (1 Viewer)

[haimbeyhan]

I have an Access 2007 adp project that loads custom ribbon from SQL server when starting. I actually created an autoexec macro that runs a public function which loads the ribbon. The project adp and ade files run and load the ribbon without problem but when I copy the ade file to user machine running Access Runtime, he gets an error "Error 430: Class does not support automation or does not support expected interface".
Acutally the problem is not with autoexec macro because if I change the macro to open a form, then there is no problem.
How can I solve this problem?

Thanks,
Haim Beyhan

 

[Avelino]

Hi Haim

I tested here with the 2010 runtime and it worked well. What is your version of the runtime? You may have used a feature on the ribbon does not work at runtime. Create a simple ribbon and make a test.

Avelino