Echo On = No crashing macro in Access 2007

G

gregl

I created a database in an earlier version of Access (2003) that contained a
macro with the Echo On = No action that worked fine. However, when I open
the database in Access 2007 and run that macro, the Status Bar Text doesn't
show and after the macro executes Access (but not my pc) is frozen. I have
to close and then reopen the database to see the results (which do appear to
be correct.) I guess this is somehow a security issue (because when I set
Echo On = Yes, the macro runs fine), but I've scoured the Help files and the
message boards, tried everything I can think of, and nothing solves the
problem. Any insight into my security settings or anything else that could
be causing this problem would be appreciated.
 
S

Steve Schapel

Greg,

Do you have another Echo action at the end of your macro to set it back to
Yes?
 
G

gregl

No I don't. Is that necessary in 2007? (I didn't need to do that in 2003.)
And does that explain why the Status Bar Text doesn't display? Thanks.
 
S

Steve Schapel

Greg,

You are quite correct, it should not be necessary. I am sorry about my
unclear previous reply... I should have said to try putting an Echo/Yes
action at the end of the macro, as an experiment as part of the process of
trying to diagnose.

The other question is that I assume you have the database in a folder that
is set up in Access 2007 as a Trusted Location?
 
R

Reed Mason

Do not know what ths about. I dd snd an inqyiry a while
I use entourage ver 10,o for Mac
 
G

gregl

Steve, replying to your response to my response to this post (which I saw on
another board where this thread appeared, but for some reason don't see here)-
Added Echo On = Yes action to end of macro - macro doesn't blow up now at
least, but of course still doesn't display Status Bar Text ("Macro is
running") embedded in Echo On = No action set at beginning of macro.
I run this macro from a form. Interestingly, when I have the form open and
run the macro while in the macro design view, I do see the desired text while
the macro is running (and it goes back to "Ready" when the macro is done)!
It doesn't blow up either, even when I remove the Echo On = Yes action from
the end.
I do have the database in a trusted location.
So this is an improvement, but I'd still like to see the Status Bar Text
"Macro is running" when I run the macro from the form.
Thanks again.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top