Access 2007 : Error 2950 appears only in ACCDE

I have a database with all macros running 开发者_StackOverflow中文版fine when the file is an accdb format , when i make the accde a message appears saying command or action "refresh" is not available now , and then when i press ok it gives an error 2950 . Please notice that i run the database from a trusted location.

Thanks, Bishoy

I suspect that this is because the form does not have focus. You could try setting the focus to the relevant form after the open macro and before refresh.

Forms("Form1").SetFocus