2007 accde not fully working on 2010

[Taaner]

Hey, I have a frontend .accde created from a .accdb with Access 2007.

It works fine on Access 2007, but when I run it with Access 2010 it seems that the form_load function of the second form is not executed. The one of the main screen works fine.
Even when I reduce the code to a minium (changing 1 text field so I see something happens) is not working.

If I make a .accde in Access 2010, it works fine (on 2010 but I can not use it with Access 2007).

Does someone has any idea what can cause this problem?
Oh, and it is the 32 bits version of Office 2010.

[zmbd]

Please read thru and do the troubleshooting steps as outlined in the following link first. If this doesn't fix the issue then uou are going to have to post the VBA behind your forms.

> Before Posting (VBA or SQL) Code

[Taaner]

I had to mention I already tried decompiling, compact & repair and re-compile, nothing works. Debuging is not possible since the problem only excists in the .accde but not in the .accdb. Like I mentioned I already reduced the code to only changing a text field on the screen in the form_load but that is not executed (and no error message).

I also searched the internet. Most issues I found were about trusted locations but in my opion this is not my case: VBA code of the main screen is executed, not the code of the second screen.

If I find some spare time I will do more testing, but if someone can give me a clue where primarly to focus on it would be much appreciated.

[zmbd]

If you are not going to do as I have suggested in post #2 then there is no help for you. We simply can not read your mind for the code nor can we do the basic troubleshooting.

[Taaner]

Like I told in post #3 I did already the basic troubleshooting, and even more like decompiling.

And because, like I also mentioned, I was almost sure it was not in the VBA code since I still had the problem with a reduced basic code in the form_load (and deleted all other methods), I didn't post the VBA code in my question.

I was only looking if someone could give me any direction to look at, because this form has different controls with different settings.

But I already managed myself to find where the problem is situated. It has to do with OLE-automation. If I delete the ActiveX control with OLE automation from the screen, the form is correctly loaded on the Office 2010 machine.

I can help the users by providing 2 versions of the front-end (a 2007 and a 2010 version), but I want to know why this is not working. When I got the time, I will do more search on this. But all tips are welcome of course ;-)

[zmbd]

and the second part to of my post was to post your code as we would have been able to see the OLE control and point you to possible solutions.

With out your control, we can't tell you which library to look for, nor, if possible, how to late bind the control.